fill DataSet using OleDbDataAdapter from Access field format is lost

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Framework
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - Split - not like perl? Hello, I am trying to use string.split to break up a string into fields. It seems as though, when using space as a delimiter, the method fails to perform as desired when more than one space delimits two fields. Am I interpreting this correctly? In perl, the following string: "this that and the other thing" would split into 6 elements. The .NET makes a fields for each space? Is there a way to handle this (other than regular expressions?) Tag: fill DataSet using OleDbDataAdapter from Access field format is lost Tag: 93912
  - 2
    - HttpWebRequest and Host header Hi... I've been working a bit with the HttpWebRequest class and one requirement I've gotten recently is the desire to set the HTTP Host: header separately from the specific machine referenced in the url. For example, the url http://frontend1.east.company.com but passing Host: www.company.com to emulate a call to the general front door. I look in the HttpWebRequest documentation on MSDN, and under the Headers property, it says specifically that the Host header's derived from the url (implying that it can't be overridden). Is there any way to do what I want to do? Thanks _mark Tag: fill DataSet using OleDbDataAdapter from Access field format is lost Tag: 93896
  - 3
    - stored procedure - ref cursor - no rows Hello, I am stumped. Hopefully another pair of eyes will see what mine cannot. I am calling a stored procedure that accepts a single output parameter [the proc has been dumbed down to limit variables of my problem] that is a ref cursor. When I make the call I get now data. I have used both adapter and datareaders. If I call the proc from another proc I can loop through the results. I am including the code of my c# function and the stored proc. The version number of my Oracle.DataAccess.dll is 10.1.0.303. ** Stored Proc *********************** TYPE refcursor is ref cursor ; procedure P_CUSTOMER_INFO_GET_SLIM( thecur out refcursor ) is begin open thecur for select * from customer_info where rownum < 21; end P_CUSTOMER_INFO_GET_SLIM; ** C# Func *************************** private DataSet _FetchCustomerData2(string CustNbr, string ShipToSuffix) { string sc = "PKG_CUSTOMER_CONTACT.P_CUSTOMER_INFO_GET_SLIM"; OracleConnection con = new OracleConnection(_Database.GetConnection().ConnectionString); OracleCommand cmd = new OracleCommand(sc, con); OracleDataAdapter da = new OracleDataAdapter(cmd); DataSet ds = new DataSet(); // must pass strings with data if (CustNbr.Length==0 || ShipToSuffix.Length==0) { return null; } try { // we are calling a stored proc so set it cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("thecur", OracleDbType.RefCursor, DBNull.Value, ParameterDirection.Output); da.Fill(ds, "Customer"); // no data ????????????????? // Close and Dispose OracleConnection object con.Close(); con.Dispose(); return ds; ... Tag: fill DataSet using OleDbDataAdapter from Access field format is lost Tag: 93893
  - 4
    - how to do conditional compilation in VB.NET? Hi How can I do conditional compliation in VB.NET? Thanks Dee Tag: fill DataSet using OleDbDataAdapter from Access field format is lost Tag: 93892
  - 5
    - Collection Class Design Question (Compound Key) Hello, I have a class that inherits from the CollectionBase class that contains records from a table in database that has a compound key. Items Table Company_ID [PK, int] Item_ID [PK, int] Description [varchar(50)] Does anyone have any suggestions on how to implement a property, similar to Item(index as Integer), that accepts the compound keys? Desired Property Item(company_id As Integer, item_id as Integer) As CompanyItem Currently if the table has only a primary key, I create a hashtable to store the primary key and the index of the object. Private m_htKeys As Hashtable Default Public Property Item(ByVal key As String) As CompanyItem Get Return list.Item(m_htKeys.Item(key)) End Get Set(ByVal Value As CompanyItem) list.Item(m_htKeys.Item(key)) = Value End Set End Property I have tried storing the compound keys as a String Array in the hashtable, however when I try to find that String Arrary again it just returns the first object. Is there a better way of going about this? Am I crazy? Justin Tag: fill DataSet using OleDbDataAdapter from Access field format is lost Tag: 93891
  - 6
    - Open window on different screen Hi, I have created a windows service that can open applications such as Word, Excel and Acrobat. Since the service is opening the application, the view of the application is not available. Is it possible to have the application that is opened by this service user to show on a different screen, such as console or even better, a remote desktop session? The application is in .NET, specifically C#. VB.NET help would also be just fine. Thanks. Steve Tag: fill DataSet using OleDbDataAdapter from Access field format is lost Tag: 93890
  - 7
    - Trying to load a .NET dll I am experiencing the following problem. I have a c++.NET dll in some directory. Let's call it ABC.dll. Now, I try to create a c# project and add this dll to it. So I add it as a reference. The project builds. When I run it, however, I get a FileNotFound exception. File or assembly name ABC (mind you without the .dll), or one of its dependencies, was not found. Even more interesting, I have another app which uses this dll without any problems, though I am not running it right now. Tag: fill DataSet using OleDbDataAdapter from Access field format is lost Tag: 93888
  - 8
    - Re: Which NIC will framework application use? Hum...typical limited response. So...does anyone know how a C# app would select which NIC to use? For example, NOT USING SOCKETS, if one were to use a simple web service url, how could a specific NIC be selected? Amil "Norman Yuan" <NotReal@NotReal.not> wrote in message news:uA021OAMFHA.2748@TK2MSFTNGP09.phx.gbl... > Framework does not make the decision. It is the application (and ultimately, > the developer) that decides which NIC to use, should the app need to access > to network resources. The app itself may have to be configured to work in a > network environment, or it may use machine's Window's network settings. All > depends on how the app is designed. > > "Amil" <AmilHanish@hotmail.com> wrote in message > news:#CsSm3$LFHA.3336@TK2MSFTNGP09.phx.gbl... > > I have a computer with two NIC cards...on different subnets. When I fire > up > > a C# Framework application, how does it select which NIC to use for > network > > access? > > > > Amil > > > > > > Tag: fill DataSet using OleDbDataAdapter from Access field format is lost Tag: 93886
  - 9
    - Socket Class Slower Then HTTP Web Request I developed an application that automates dwonloading of a web page hundreds of times. I first developed it by using http web request, but then I read up that HTTP Web Request has some overhead that I thought I could eliminate if I re-wrote it with sockets. However, what I have found is that sockets actually works significantly slower (I get about 1/2 to 2/3 of the performance I get with HTTPWebRequest). Now, the web server sends a close command on every request so even if I post a Keep-Alive request I have to create and open a new socket for every request, but I assume the HTTPRequest class must do the same thing under the covers. Below is my Socket Send Method (very basic). Can anyone explain this strange disparity in performance? public string Send(string strRequest) { m_sock = new Socket(ipe.AddressFamily, SocketType.Stream, ProtocolType.Tcp); m_sock.Connect(ipe); string strRetPage = null; Encoding ASCII = Encoding.ASCII; Byte[] ByteGet = ASCII.GetBytes(HttpRequest); Byte[] RecvBytes = new Byte[256]; m_sock.Send(ByteGet, ByteGet.Length, 0); Int32 bytes; do { bytes = m_sock.Receive(RecvBytes, RecvBytes.Length, 0); strRetPage = strRetPage + ASCII.GetString(RecvBytes, 0, bytes); } while (bytes > 0); m_sock.Shutdown(SocketShutdown.Both); m_sock.Close(); return strRetPage; } Tag: fill DataSet using OleDbDataAdapter from Access field format is lost Tag: 93882
  - 10
    - Release Dates Can anyone point me in the direction of a list for the release dates for .Net including all betas, RCs, 1.0 & 1.1 I don't want 'sometime in Sept 2001' I need a definite list if there is one. Cheers Interviewer Tag: fill DataSet using OleDbDataAdapter from Access field format is lost Tag: 93876
  - 11
    - Windows Authentication question Hi. We are creating an intranet here in ASP.NET and we decided that we are going to use a kind of Forms Authentication but using the users in our windows domain. So, we are creating a default login form, but the user will use the name and password he uses to login to his computer. I would like to know 2 things: 1. How can I get a list of Windows users in my domain, so that I can list them for administration purposes. 2. After getting username and password from the user, how can I check it against my domain users to see if I should grant him access? thanks. Tag: fill DataSet using OleDbDataAdapter from Access field format is lost Tag: 93875
  - 12
    - Dispose problem with circular references Hi, I need to implement Dispose() for some objects that contain references to one another... fromObject -> (contains reference to) toObject ViewObject->TableObject->IndexObject ViewObject<-TableObject if i implement dispose for all of them and call dispose for fields that implement IDisposable - as FxCop rule says - i get stackoverflows... i read some papers, but each of them says diferrent things (?!)...even when sources are from MS...:))) another thing, in dispose do i set all reference objects to null? some says yes, some says no...what the heck is this?? so...how can i do this properly? Thank you very much, Daniel Tag: fill DataSet using OleDbDataAdapter from Access field format is lost Tag: 93872
  - 13
    - Setting a from alias when sending mail using Mail.MailMessage How can I add an alias when sending mail using Mail.MailMessage in VB.NET? I would like to do this: Dim msg As new Mail.MailMessage msg.From = MagSoft <magnus@company.com> msg.Send But this picks up my real name Magnus Österberg (stored in the SMTP server?) and shows that as sender when I view the e-mail in Outlook. Tag: fill DataSet using OleDbDataAdapter from Access field format is lost Tag: 93871
  - 14
    - Connecting to internet.. Hi all, this is a query more than a problem. I have a task in hand, whose scenario is as follows. i have a window application, using a button on which (say 'upload' or 'download') i need to connect to internet and then open my abcd.aspx page to process the text file passed.. The problem is not in sending or fetching the file or to process it, but the problem is the first step. If the client is not connected to the internet at the moment he presses the button, my application is suppossed to connect to the internet directly.. it means no processig window of the conecting application (say the one which is installed to connect to internet) should be opened.. how to even begin with this i am not clear.. pls help! thanks & regards Paras Tag: fill DataSet using OleDbDataAdapter from Access field format is lost Tag: 93870
  - 15
    - MessageFilters I want to create an application message filter that re- maps certain keystrokes. I need to be able to do this for=20 certain types of non-standard keyboards. For example, if=20 a user presses 'A', the underlying form should receive=20 a 'B'. My first idea was to use an IMessageFolter and=20 change the value of the WParam of the incoming message.=20 Since it is declared as a ref parameter, I was hoping=20 that it might work. Id does not. The code runs and the=20 value is changed, but the form still receives the=20 original message. It would be interesting to know why it doesn't work, but=20 even more I would like to know the correct way to do a=20 thing like this. regards G=F6ran Tag: fill DataSet using OleDbDataAdapter from Access field format is lost Tag: 93869
  - 16
    - This can't be true try running this C# code in VS.NET 2003: using System; namespace ExitCode { class MainClass { static int Main(string[] args) { return 7; } } } run it under the debugger, and what do you get? The program '[4552] ExitCode.exe' has exited with code 0 (0x0). see? zero, not seven. Is this a bug or what? Tag: fill DataSet using OleDbDataAdapter from Access field format is lost Tag: 93867
  - 17
    - Code Converter Some time ago, I came across an application that would convert one .NET language to another. What was unique about this converter was that it also worked with C++.NET. I long since misplaced it... Does anyone know what product this was, or know of another? Thanks all. -- ROT-13 my email address to reply directly Tag: fill DataSet using OleDbDataAdapter from Access field format is lost Tag: 93862
  - 18
    - BIFF8 Excel Reader Besides using Interop and ADO.NET, I;d like to know where can I get a BIFF 8 Excel reader in .NET which is free or GNU license? I'm not interested to get a third party which need to pay. I need a BIFF8 reader to read an excel file upload by a user. This BIFF8 reader need to to be perfect but can read all the values in a few worksheets. I don't wish to use interop and ado.net at the moment. I found a writer instead @ www.freevbcode.com/ShowCode.Asp?ID=6856 although this writer is in VB6 format. Tag: fill DataSet using OleDbDataAdapter from Access field format is lost Tag: 93856
  - 19
    - Data Form Wizard: value cannot be null, parameter name: type PROBLEM: I saw previous posts on the issue where you try to use the Data Form Wizard and you get the error: Data Form Wizard: value cannot be null, parameter name: type I also saw various solutions. None of which worked for me. I am using Version 2003 of Visual Studio .NET. SOLUTION: You can't name your Dataset the same as your table name that will be in the dataset or you will get this error. For example, I called my dataset "Agent" and my database table name was also "Agent". This choked. When I changed the dataset name to Agent01 and selected Agent table, it worked correctly. FYI. Tag: fill DataSet using OleDbDataAdapter from Access field format is lost Tag: 93855
  - 20
    - Cross AppDomain Communication, Scripting Howdy All, I am having difficulty with two-way communication across AppDomains in an attempt to dynamically script applications. Everything works as expected, except when using ByRef parameters. The below explanation is lengthy, but well worth the read. If you can help me, I'd gladly share this code which has greatly helped my development of extensible applications. I have developed an easy to use scripting engine for .NET that handles loading and unloading of a secondary AppDomain automatically. I call the object "SafeScriptingEngine", and it has properties for the source language, source code, and any needed references and imports. When its compile method is called, the code is compiled by the appropriate compiler, then it creates a new AppDomain, loads the compiled code into the AppDomain, and uses a Class Factory approach to return a well-known interface. This simple interface contains two functions called "MethodExists", which accepts a function name and a list of parameters then return a Boolean of whether the function exists, and "CallMethod", which again accepts a function name and a list of parameters then actually calls the function. Public Interface IRemoteLoader Function Invoke(ByVal methodName As String, ByVal parameters() As Object) As Object Function MethodExists(ByVal methodName As String, ByVal parameters() As Object) As Boolean End Interface So, an example of using this engine looks like: Dim sse As New SafeScriptingEngine() sse.Language = Languages.VisualBasic sse.SourceCode = "" & _ "Public Function UpperString(ByVal s As String) As String" & _ " Return s.ToUpper" & _ "End Function" If sse.Compile() Then If sse.MethodExists("UpperString", New Object() { "" }) Then MsgBox(sse.CallMethod("UpperString", New Object() { "this string will be converted to uppercase" })) End If End If All of this works great. There are no memory leaks, and all compilers, AppDomains, and assemblies are unloaded as desired and expected. In fact, I designed the engine to be inheritable such that functions can be created that are strongly typed. As you can see, the default engine expects a non-strongly-typed array of Objects. To prove the usability of the engine, I created a "SimpleStringScript" which inherits from the "SafeScriptEngine". The "SimpleStringScript" accepts only the part of code that does the manipulation, such as "s.ToUpper" in the example above. In the background, it adds function, parameters, and Return statement. Also, with the "SimpleStringScript", there is no need for "MethodExists" that accepts parameters. Instead, it has a "StringMethodExists" function that accepts no parameters, which then calls "MethodExists" on the base "SimpleStringScript" with a String Object as the parameter. Likewise, there is no need to call "CallMethod" with a function name and Object array. Instead, it has a "CallStringMethod" function that take a String as a parameter, which in turn calls the base "CallMethod" with the appropriate function name and the String parameter encased in an Object array. Public Class SimpleStringScript Inherits SafeScriptingEngine Public Function CallStringScript(ByVal s As String) As String Public Function StringMethodExists() As Boolean ... End Class Again, all of this works great, just as desired and expected. The problem arises when you create a script that uses ByRef parameters. I would like a function that looks like: Public Sub MyCustomFunction(ByRef e as MyEventArgs) e.MyObject.MyProperty = "some value" End Sub I quickly discovered that any parameter being passed into another AppDomain must be Serializable, as do any objects that are referenced in its hierarchy. Otherwise, it will throw a SerializationException when you try to pass in the parameter. So, I changed all objects that are referenced in the EventArgs to be Serializable, and that solved the problem when calling. However, upon return to the calling AppDomain, the objects and values in "e" are still the same as before the call. None of the manipulations taking place in the script from the secondary AppDomain are carried back to the calling AppDomain. I figure this is because, as expected with the Serializable objects, the "e" is being serialized, sent across the AppDomain boundary, then deserialized. When it is deserialized, an entirely new object is created. Changes made are not sent back across the boundary simply by using ByRef arguments. Unfortunately, I'm not sure exactly how to solve this problem. I think I should be sending an Interface as my argument, rather than an object of MyEventArgs. As long as the Interface is well-known in both AppDomains, I think the scripting AppDomain should know what to call, and when it does, the call should be marshaled back to the primary AppDomain via the Interface. Basically, the Interface is just a pointer back to the actual object. Can anyone confirm this to be True or False? If False, please HELP! If True, then is it possible to simply wrap the MyEventArgs object into an Interface, such as "IMyEventArgs", then change the scripted function to accept the Interface rather than the object, then pass an Interface rather than an object into the method? Would that suffice, so long as both AppDomains are aware of the Interface and anything it references? Obviously, if the Interface referenced a type that is not loaded in the secondary AppDomain, then there would be problems because the script would not know how to use it. Or, do I have to wrap the EventArgs into an Interface, as well as wrap every object that it references into an Interface. Meaning, again using the example above, would I also need to create an "IMyObject" Interface? My workaround for the time being is to return the object being manipulated as the return value, that way, the new object (created from deserialization) is again serialized upon return. However, this requires the scripter to know that they need to return it. Using C#, that is no big deal because the compiler will tell you when there is nothing returned. However, in Visual Basic, if you fail to supply a return value, you simply get Nothing. But, since I will be writing the scripts, I'll deal with the workaround for now. But, I sure would like ByRef to work across AppDomains. Any suggestions? Thanks in advance, Matthew ___________________________________ Matthew Roberts Framework Architect Business Process Solutions SOURCECORP Dallas, TX 75204 matthewroberts (at) srcp (dot) com Tag: fill DataSet using OleDbDataAdapter from Access field format is lost Tag: 93854
  - 21
    - Which NIC will framework application use? I have a computer with two NIC cards...on different subnets. When I fire up a C# Framework application, how does it select which NIC to use for network access? Amil Tag: fill DataSet using OleDbDataAdapter from Access field format is lost Tag: 93852
  - 22
    - i give up....parse string hello i want to parse/rplace/construct wahtever a string i get i read with directoryinfo out the root off my webapplikation Dim dirInfo As New DirectoryInfo(Server.MapPath("")) c:\inetpub\wwwroot\TEST i store this in a variable called physicalbasepath i list all folders in a datagrid and adds a buttoncollmn that executes using this which steps me one level into the filesystem Dim dirinfo As New DirectoryInfo(Server.MapPath(e.Item.Cells(1).Text)) ' where cell1 contains the full path of that dir i wanna go in to i store this in a variable called subphysicalbasepath i now have c:\inetpub\wwwroot\TEST and c:\inetpub\wwwroot\TEST\subfolder1 ' here we can get deep in so we must keep all from TEST\.....\and down i wanna turn this into http://server.domain.com/test/subfolder1 - this must be dynamic so i can use on any server and the folders can have any name i gets the urlpath using this Dim basepath As String = Request.Url.GetLeftPart(UriPartial.Authority) + ResolveUrl(Request.ApplicationPath) which gives me http://server.domain.com/test my though was to replace c:\inetpub\wwwroot\TEST\subfolder1 with basepath so it looks like this http://server.domain.com/test\subfolder1 then i can easy switch the \ to a / i can only accomplish this if i use this - replacing char with string Dim virtualpath1 As String = dirinfo.FullName.Replace("c:\inetpub\wwwroot\TEST", basepath) this gives http://server.domain.com/test/\subfolder1 which is what i want but not dynamic enough It wont work use this replace string to string Dim virtualpath1 As String = dirinfo.FullName.Replace(subphysicalbasepath,basepath) this gives c:\inetpub\wwwroot\TEST\subfolder1 Tag: fill DataSet using OleDbDataAdapter from Access field format is lost Tag: 93848
  - 23
    - httpwebrequest when RSA/ACE securid server is involved Hello, I have an assembly, written in C#. The assembly runs under IE (6.0 SP1). IE accesses a web site on which a reverse proxy with an RSA/ACE secureid is installed. When this happens an authentication process takes place and after its completion, the web request goes through and completes successfuly. Naturally, any further http requests to the same site will not have to re-authenticat. However, my C# assembly runs under IE and tries to invoke an http request via the standard httpwebrequest class. I am setting HttpWebRequest.Credentials = CredentialCache.DefaultCredentials still, it does not help. Any idea what I am missing here? Thanks, Ilan Tag: fill DataSet using OleDbDataAdapter from Access field format is lost Tag: 93841
  - 24
    - Problems installing Framework 1.1 of WinXPsp2 Just bought new notebook with Windows XP pro sp2. Trying to install ACT!, which requires .net framework 1.1. But I get the follow message during the installation of .net: application has generated an exception that could not be handled process id=0xc48(3144) thread=0xc9c(3228). The installation is then halted. Do I need to install Framework 2.0 beta?, or is is a matter of firewall settings, etc.? Thanks Tag: fill DataSet using OleDbDataAdapter from Access field format is lost Tag: 93839
  - 25
    - corrupted net 1.1 framework install I have a corrupted framework install. I can not uninstall or reinstall. I tried to reinstall following the kb article but I get the same error. The install is looking for a temp file tmp4B.tmp and can't find it. Any ideas? Thanks Fr. Robert Tag: fill DataSet using OleDbDataAdapter from Access field format is lost Tag: 93837
- Next
  - 1
    - Combobox text not in list strange behaviour Here is a weird one. I have a combobox that accepts and displays values that are not in the list. However if I do a droppedDown = true in the onEnter event handler and then tab to another combobox, the text value is reset to null/empty string. My solution at this point is to separate the two comboboxes with a textbox so that doesn't happen. (Note that it also resets to null if i step through through the droppeddown = true statement.) If anyone has seen this or heard of fix for it, please let me know. Thanks, Carl Here are code snippets pertainent to this: ' 'cboPaymentType ' Me.cboPaymentType.Enabled = False Me.cboPaymentType.Location = New System.Drawing.Point(152, 160) Me.cboPaymentType.Name = "cboPaymentType" Me.cboPaymentType.Size = New System.Drawing.Size(104, 21) Me.cboPaymentType.TabIndex = 2 ' 'cboPaymentMethod ' Me.cboPaymentMethod.Enabled = False Me.cboPaymentMethod.Location = New System.Drawing.Point(320, 160) Me.cboPaymentMethod.Name = "cboPaymentMethod" Me.cboPaymentMethod.Size = New System.Drawing.Size(104, 21) Me.cboPaymentMethod.TabIndex = 4 'payment type Me.cboPaymentType.DataBindings.Add("SelectedValue", Me.OrderDS, "Orders.OrdersOrderPayments.PaymentTypeFK") ' binding to the Text property appears to allow a value not in the list to be entered, saved, and displayed. Me.cboPaymentType.DataBindings.Add("Text", Me.OrderDS, "Orders.OrdersOrderPayments.PaymentTypeFK") Me.cboPaymentType.DataSource = Me.PaymentTypeDS Me.cboPaymentType.DisplayMember = "PaymentType.PaymentTypeName" Me.cboPaymentType.ValueMember = "PaymentType.PaymentTypeName" ' do it twice to get around bug Me.cboPaymentType.SelectedIndex = -1 Me.cboPaymentType.SelectedIndex = -1 'payment method Me.cboPaymentMethod.DataBindings.Add("SelectedValue", Me.OrderDS, "Orders.OrdersOrderPayments.PaymentMethodFK") ' binding to the Text property appears to allow a value not in the list to be entered, saved, and displayed. Me.cboPaymentMethod.DataBindings.Add("Text", Me.OrderDS, "Orders.OrdersOrderPayments.PaymentMethodFK") Me.cboPaymentMethod.DataSource = Me.PaymentMethodDS Me.cboPaymentMethod.DisplayMember = "PaymentMethod.PaymentMethodName" Me.cboPaymentMethod.ValueMember = "PaymentMethod.PaymentMethodName" ' do it twice to get around bug Me.cboPaymentMethod.SelectedIndex = -1 Me.cboPaymentMethod.SelectedIndex = -1 Private Sub cboPaymentMethod_Enter(ByVal sender As Object, ByVal e As System.EventArgs) Handles cboPaymentMethod.Enter CType(sender, ComboBox).DroppedDown = True End Sub Private Sub cboPaymentType_Enter(ByVal sender As Object, ByVal e As System.EventArgs) Handles cboPaymentType.Enter CType(sender, ComboBox).DroppedDown = True End Sub Tag: fill DataSet using OleDbDataAdapter from Access field format is lost Tag: 93836
  - 2
    - HttpWebRequest ->HttpWebResponse question Hi... I ran into an odd circumstance using HttpWebRequest. Specifically, when you call GetResponse() it throws a WebException, to quote the msdn page, Abort was previously called. -or- The time-out period for the request expired. -or- An error occurred while processing the request. The last item is the part I find quizzical. "An error occurred while processing the request" appears to cover any non-200 return status while ignoring that, say, a 404 or a 500 status *can* have a payload that is of interest. A custom error page, or a 500-page might have information about what went wrong. Is there any way to get ahold of the payload when the return status is not 200? GetResponse errors out, and I can't find a property to stop that. Thanks -Mark Tag: fill DataSet using OleDbDataAdapter from Access field format is lost Tag: 93835
  - 3
    - DirectorySearcher.FindOne() fails when LDAP path contains "/" Hello, I have a method that is used to find all of the distribution lists and security groups that a user belongs to. This works fine, except when the LDAP path looks like the following: CN=aaa/ aaaaa,OU=Distribution Lists,DC=string,DC=string,DC=string,DC=com I've found that everytime the DirecotrySearcher.FindOne() encounters a path that contains a '/' in the CN portion, it throws an exception. Below is the exception: Source: System.DirectoryServices Message: Unknown error (0x80005000) Stack Trace: at System.DirectoryServices.DirectoryEntry.Bind(Boolean throwIfFail) at System.DirectoryServices.DirectoryEntry.Bind() at System.DirectoryServices.DirectoryEntry.get_AdsObject() at System.DirectoryServices.DirectorySearcher.FindAll(Boolean findMoreThanOne) at System.DirectoryServices.DirectorySearcher.FindOne() at ADUtilityTester.ADUtilities.getDLList(String sDomain, String sUser) in c:\\documents and settings\\username\\my documents\\visual studio projects\\adutilitytester\\adutilities.cs:line 74 Line 74 is: SearchResult schRes = ds2.FindOne(); I've tried escaping it, but then it just doesn't find anything. Any ideas on how to get around this problem? -- Michael Bayha Tag: fill DataSet using OleDbDataAdapter from Access field format is lost Tag: 93834
  - 4
    - Setting Printer Hi, can anyone pleasse tell me how to set the lpi on a doe matrix printer via code. VB.Net preferablly. It could be thdough windows API, it doesn't matter. Thanks Tag: fill DataSet using OleDbDataAdapter from Access field format is lost Tag: 93826
  - 5
    - windows service Hi, I have created a Windows service. In the project there is one service and one installer. I have also created a Setup project. When I run my msi file the service will not be installet into the Computer Manager/Service... the application are installed into the Porgram Files/MyApp folder. How can I trouble shoot this? Thanks Julia Tag: fill DataSet using OleDbDataAdapter from Access field format is lost Tag: 93824
  - 6
    - Word wrapping in Graphics.DrawString breaks words at umlauts Hi, I use Graphics.DrawString(string, Font, Brush, Rectangle, StringFormat) to render a string inside a rectangle with word wrapping. It works fine so far, but: If words contain german umlauts (ä, ö, ü etc.), lines are broken before or after these characters. The umlauts seem to be considered as delimiter characters. I can't find a language setting in the Graphics class or in the StringFormat class either. I tried to set stringFormat.SetDigitSubstitution(System.Globalization.CultureInfo.InstalledUICulture.LCID,StringDigitSubstitute.Traditional); but to no effect. TIA Franz Tag: fill DataSet using OleDbDataAdapter from Access field format is lost Tag: 93821
  - 7
    - Line numbers of methods in dynamically generated assemblies Hello, I am dynamically compiling .cs files to In-Memory assemblies at runtime using CodeDom. This works fine. The resulting assembly is parsed via reflection to detect the implemented class and the the methods of that class. This works fine, too. Now, I want to match the detected methods to the responding lines of code of the original source file. This is the problem! Maybee I have overseen something, but after a hard day trying to understand and use the System.Diagnostics.SymbolStore namespace, I am completely stuck. The methods of the SymbolStore seem to be only partially implemented and they are quite poorly documented. Does anyone have an idea how to get the line numbers of the first and the last line of a method, from which I have the MethodInfo? Any idea is greatly appreciated! Thanks in advance Uli Tag: fill DataSet using OleDbDataAdapter from Access field format is lost Tag: 93820
  - 8
    - Cost of using functions [vb.net] I was wondering if the use of functions decreases performance over placing all code after each other. For example: Instead of having function write anything to the screen using Response.Write(strMessage), I usually call a function DisplayMessage (strMessage), but now I'm wondering if this has any impact on the performance, or does the Framework recode (or how it is called) this to effecient code anyway. The main advantage is that, if I decide that those functions should not write anything to screen, I just have to disable that in only one place. Plus readability is increased :) Merely curious, as it is not really a performance issue, I'm wondering what the groups thoughts are about this. -- Message posted via http://www.dotnetmonster.com Tag: fill DataSet using OleDbDataAdapter from Access field format is lost Tag: 93817
  - 9
    - List of users for a folder How to retrieve a list of groups and/or users that have access permission to a folder? Thank you. Tag: fill DataSet using OleDbDataAdapter from Access field format is lost Tag: 93815
  - 10
    - BIFF8 Excel Reader Besides using Interop and ADO.NET, I;d like to know where can I get a BIFF 8 Excel reader in .NET which is free or GNU license? I need a BIFF8 reader to read an excel file upload by a user. I don't wish to use interop and ado.net at the moment. I found a writer instead @ www.freevbcode.com/ShowCode.Asp?ID=6856 although this writer is in VB6 format. Tag: fill DataSet using OleDbDataAdapter from Access field format is lost Tag: 93814
  - 11
    - get application path Hi, how can I get the path of my application? If the application is located in C:\Program Files\MyApp, I want to be able to get this path in the code so I can save a text file in this location. Thanks Julia Tag: fill DataSet using OleDbDataAdapter from Access field format is lost Tag: 93810
  - 12
    - Problem deploying C# application with ClickOnce Hi all, I've created a simple application in C# to test for ClickOnce deployment. After I've compiled the exe, I created the deployment manifest and the application manifest with "mageui.exe", and then put it onto a folder which could be recognized by IIS. I tried to click on the .application file in Windows Explorer, and the application is installed with no problem. Then I tried to do the same thing through a web browser, typing the URL directly. The update screen comes out normally, but after that an error message telling me that "Unable to continue. The application is improperly formatted. Please contact the vendor." is shown. The exception is attached at the end of this message. Since the XML files are created by mageui.exe without being modified, I think they should have no formatting problem. And I have already specified the Publisher. So is there anything that could cause this problem? (FYI I'm using English WinXP, and have my default language for non-Unicode programs set to Chinese (Taiwan)). Thank you. Dominic --------------------- Exception given: Windows version: 5.1 system.deployment.dll (in C:\WINDOWS\Microsoft.NET\Framework\v2.0.40607) version: 2.0.40607.42 (beta1.040607-4200) mscorwks.dll version: 2.0.40607.42 (beta1.040607-4200) dfdll.dll version: 8.0.40607.42 (beta1.040607-4200) Subscription Url: C:\Documents and Settings\User\Start Menu\Programs\dominic\Sample application using ClickOnce deployment..appref-ms (23/03/05 12:41:34 PM) Activate manifest: Activation of C:\Documents and Settings\User\Start Menu\Programs\dominic\Sample application using ClickOnce deployment..appref-ms resulted in exception. Type: System.Deployment.ManifestParseException Exception reading manifest from file 8b550599-633d-4caf-a070-6f0008b0f4ac.application: the manifest could be invalid or the file could not be opened. Source: System.Deployment Stack trace: at System.Deployment.ManifestReader.ExceptionHelper(String filename, Exception ex) at System.Deployment.ManifestReader.FromDocument(String docPath, ManifestType manifestType) at System.Deployment.DownloadManager.DownloadManifest(Uri& sourceUri, String targetPath, IDownloadNotification notification, DownloadOptions options, ManifestType manifestType) at System.Deployment.DownloadManager.DownloadDeploymentManifestDirect(SubscriptionStore subStore, Uri& sourceUri, TempFile& tempFile, IDownloadNotification notification, DownloadOptions options) at System.Deployment.DownloadManager.DownloadDeploymentManifest(SubscriptionStore subStore, Uri& sourceUri, TempFile& tempFile, IDownloadNotification notification, DownloadOptions options) at System.Deployment.ApplicationActivator.PerformDeploymentUpdate(SubscriptionState subState) at System.Deployment.ApplicationActivator.ProcessOrFollowShortcut(String shortcutFile, TempFile& deployFile) at System.Deployment.ApplicationActivator.PerformDeploymentActivation(Uri activationUri, String deployLocalCachePath, Boolean isShortcut) at System.Deployment.ApplicationActivator.ActivateDeploymentWorker(Object state) --- Inner Exception --- Type: System.Xml.XmlException There are multiple root elements. Line 1, position 49. Source: System.Xml Stack trace: at System.Xml.XmlTextReader.Throw(Exception e) at System.Xml.XmlTextReader.Throw(String res, String arg) at System.Xml.XmlTextReader.Throw(Int32 pos, String res) at System.Xml.XmlTextReader.ParseDocumentContent() at System.Xml.XmlTextReader.Read() at System.Deployment.XmlFilteredReader.Read() at System.Xml.XmlTextReader.Skip() at System.Deployment.XmlFilteredReader.Read() at System.Xml.XmlValidatingReader.Read() at System.Deployment.ManifestReader.FromDocument(String docPath, ManifestType manifestType) Tag: fill DataSet using OleDbDataAdapter from Access field format is lost Tag: 93808
  - 13
    - Clientside scripting and Popup windows. How do I develop client-side popup windows that they have at http://my.msn.com/? I know that some of this will be available in Asp.net 2.0. I may need this before the end of the release of 2.0. I know about confirm and alert, but I need something more sophisticated. Tag: fill DataSet using OleDbDataAdapter from Access field format is lost Tag: 93793
  - 14
    - Serialize / Deserialize sub-classed TreeNode I have created a new class, inherited from TreeNode, and wish to be able to use binary serialization with it. I have marked the class as serializable, however the object will not deserialize correctly (error: "The constructor to deserialize an object of type xMapNodeSerialize.MapNode was not found"). I have also thought about implementing ISerializable, however the base TreeNode class already implements this and does not allow protected access to it's special constructor or GetObjectData override. Any ideas anyone? Thanks, Chris simple code example: Imports System.Runtime.Serialization <Serializable()> _ Public Class MapNode Inherits TreeNode #Region "Constructors" Public Sub New() MyBase.New() End Sub Public Sub New(ByVal text As String) Me.New() MyBase.Text = text End Sub #End Region End Class Tag: fill DataSet using OleDbDataAdapter from Access field format is lost Tag: 93792
  - 15
    - SortedList question-- easy way to look for dupes? Hi everyone, I've been reading through the MSDN documentation on SortedLists and didn't find anything that leapt out at me about this, so I thought I'd ask; is there a "good" way to check if a SortedList has duplicate values? What about looking for duplicate values in two SortedLists?-- is there a reccomended method for looking for dupes in that instance? Tag: fill DataSet using OleDbDataAdapter from Access field format is lost Tag: 93791
  - 16
    - How to configure the DateTimePicker control to accept 24:00? I have a DateTimePicker control on a Windows form. What I want is to configure it to recognise 24:00:00 as a valid time. I only intend to use the return value as a string (i.e. not DateTime variable) How can I do this? Many thanks. Tag: fill DataSet using OleDbDataAdapter from Access field format is lost Tag: 93782
  - 17
    - Producer/Consumer example I am building an application where data is coming in from a hardware deveice attached to the serial port. The data needs to be queued ASAP. I figured a could create a custom class containing this data and store it in an ArrayList for future processing. I want to process this data continually so that is could be preserved in case of a system failure. I was thinking of implement a producer/consumer relationship using threading. However, I haven't been able to find an example that explains things in a way that I can digest. Does anyone know of any good resources for developing producer/consumer systems with C# and Threading? Thanks. Ryan. Tag: fill DataSet using OleDbDataAdapter from Access field format is lost Tag: 93777
  - 18
    - performance issue when the interpolation mode (GDI+) Hi, I have a performance issue when the interpolation mode is set to Bicubic. The image (of size 1 MB) is zoomed 10 times. When the image is viewed using scroll bars in a picturebox control, there is a choppy effect, where as, when the interpolation mode is set to HiQualityBicubic (or for any other mode, apart from Bicubic), this effect is not to be seen. Any ideas... Thanks in Advance Tag: fill DataSet using OleDbDataAdapter from Access field format is lost Tag: 93774
  - 19
    - Read / write text file? I need to update some lines in a text files. I would like to open the file, read line by line and change the lines that should be changed and then when finished the file should have been changed. I know how to do this if I open one file and write out to a second file, but how can I do this with a single file without creating a new one? Olav Tag: fill DataSet using OleDbDataAdapter from Access field format is lost Tag: 93769
  - 20
    - mutex locks: should I lock out concurrent readers, or just writers? Or should I say, when I have data members that can be read from multiple threads, should I put a lock around read-only access to those members in addition to the write-accesses of those members? What if a reader attempts to read the data while the writer is in the midst of writing to it? Thanks, -- kov Tag: fill DataSet using OleDbDataAdapter from Access field format is lost Tag: 93767
  - 21
    - Threads how to get variables... Hi! How i pass variables into threads? For example: Dim t1 As New Thread(AddressOf CfgInject) Dim t2 As New Thread(AddressOf CfgInject) t1.start t2.start Cfginject, can be called n times, i need to now inside the function what is the current thread... Tag: fill DataSet using OleDbDataAdapter from Access field format is lost Tag: 93761
  - 22
    - How do I print to a PNG-file? Hi! A have developed a windows app in VB.NET that has some printing of charts and such stuff. Is there an easy way to save the outprint in an PNG-file instead? I want exactly the same look in the image as in the outprint. -- Regards, Lars JÃ¶nson Tag: fill DataSet using OleDbDataAdapter from Access field format is lost Tag: 93759
  - 23
    - HttpWebRequest with ssl problem Hi support I' m sending requests to a web server over an ssl connection to a server with the HttpWebRequest class. I can't control the server. I make a login, send some requests but the server has no logout. This works only once. The second time I get a http error. I restart the application and everything works fine again. The programmer of the server application advised me to just destroy the ssl connection and after that log in again. That's the point: how can I destroy the ssl connection in visual basic.net. Regards Dieter Tag: fill DataSet using OleDbDataAdapter from Access field format is lost Tag: 93758
  - 24
    - Garbage Collection Hi, I have a windows app that i'm using to transfer images from one SQL DB to another doing some processing inbetween because the DB table structures to hold the images are different. What i'm finding is that the process fails after several hundred images with an Out Of Memory Exception. I can see from Task Manager that my app is chewing up memory (over 1GB) just before I get this error. I've have double checked all my code and i'm closing all DB connections and memory streams etc so in theory there should be no memory leaks. It just seems that the garbage collector is not being called, even when I make an explicit call to GC.Collect it doesn't seem to get called... Any ideas? Tag: fill DataSet using OleDbDataAdapter from Access field format is lost Tag: 93756
  - 25
    - Proposed MSDN Subscription Changes - VERY BAD!!! I urge every developer who has an MSDN subscription (Universal) to petition MS to change their proposed ideas on Visual Studio Team Suite (VSTS). Depending on what you read, they are proposing to not include it or raise the price to between $5,000 and $10,000. Every developer who has helped MS make loads of cash of these past many years needs to write to them. Let them know they are about to alienate the one group that always and consistently helps them be successful. It is the most ridiculous thing they've ever proposed. Unbelievable!!! http://lab.msdn.microsoft.com/productfeedback/viewfeedback.aspx?feedbackId=2b58b8db-5bba-4dfc-be10-78ad43686b3b MICROSOFT PLEASE RECONSIDER. YOU WILL LOSE SALES. YOU WILL ALIENATE ALL CLASSES OF DEVELOPERS! We are the ones that stick up for you when everyone bashes MS. Help us help you! GClark Tag: fill DataSet using OleDbDataAdapter from Access field format is lost Tag: 93755

I have an Access database that has an input mask on a field, !\(999")
"000\-0000;0;_ , that formats a phone number. When I fill a DataSet
using an OldDbDataAdapter some of the records lose the formatting. For
example:

Sam Jones (999) 555-1212 *this is good*
Joe Smith 9995551212 *this is bad*

Why would some records lose the formatting? There is no rhyme or reason
(that I can see anyway) why some records keep the formatting and some
lose it.

Thanks in advance for the help and plese let me know if you need any
more detail.

Top