Hello I want to insert data from TABLE Master into TABLE tempAr. I have the following so far. Both tables are in a Access Database What am i doing wrong? steve SQLStatement = "Insert into tempAr(MasterId,Payment)(Select MasterId,Cust_leasePmt from masterwhere cust_methodofPayment=2)" SetU...more >>

hi, i have created a connection and using the oracle connection + oracle data adapters, but when i try to change the select statement and re-fill the datagrid; i get nothing. however, when i fill the data adapter from the data adapter interface/wizard; the datagrid is filled when i run it. what ...more >>

In MS Access 2002, there's a functionality that will allow me to import an XML file into the database. Is there a way to do this programatically using VB.Net? Thanks for any ideas. Cesar ...more >>

I create oledbcommand to query Access database e.g. (select accno,accname,email from account ...). If I use ExecuteScaler, I get only accno. If I use ExecuteNonQuery, it does not work. Of course, I can use ExecuteReader. But, can I do with ExecuteNonQuery? Thanks. Joe. ...more >>

I am trying to create my first SQL Server 2000 app deployment. What I am concerned about is the app won't be able to connect to another machine via MSDE 2000 once installed because I have my own machine name/SQL server name coded into the connection string. I know how to make the string use variable...more >>

Hi, while trying to load excel file with oledb connection, it seem to turn integer values in string fields into DbNull, i also tried copy & paste with the clipboard and the CSV but i cant find any tool that would parse the data back into a dataset / table is there a solution out there ? thanks....more >>

I've seen other posts about such errors, but never a solution. It seems to appear randomly under load. We are pretty vigilant about "using" IDataReader's and Connections, so it's pretty unlikely that we're doing something outwardly wrong that would excuse this sort of behavior. The stack is: ...more >>

I have a delete statement that when run from Query Analyzer takes about 45 minutes to complete. When I put that statement into a dataAdapter and execute with an ExecuteNonQuery, it gets a timeout after a few seconds. How can I keep this long running process from getting a timeout? Putting Con...more >>

I have a dataset with one table and I want to find a specific row # or index in that table where one of the columns (which contains a unique value) is equal to a value I pass. Any help? ...more >>

Dear Authorities: Could you please tell me how to get a list of all ADO Providers on a client machine (without using the DataLink). I would assume they are within the Registry but I don't know where to look. Your answer to this question would be well appreciated. Sincerely, Burton G...more >>

I have to modify existing code which doesn't use transactions at all. It only uses OleDbCommands to execute SQL Statements against the DB. I know that each of the commands must have their Transaction property established, but i don't want to modify all of the commands, which are many. Is the...more >>

Hi All, I have the following code. It is pretty simple and doesn't work. All I am trying to do is open a file and put the data into an oracle clob using ADO.NET and the Microsoft Oracle Data Provider for .NET. Can anyone see what is wrong, or have a simple sample? Thanks!! Jeff ...more >>

When displaying data from the database, very often the field names are not suitable so custom headings have to be created, For example, the column storing zip code may be named zip, but when displayed, it may need to be displayed as "Zip", "Postal Code", "Zip/Postal Code" etc. DataGrid/DataList...more >>

Any built-in methods in ADO.net that will allow for a quick way to = export a csv file? Not that it is that hard to do manually, I'm just = wondering if I have missed something. Thanks, --Michael...more >>

Hi I've posted a similar question to the VB.net group but others suggested that I may have more success here. I'm trying to drop a table, called books, by using: Dim cmd As New OleDbCommand("DROP TABLE IF EXISTS books", myconnection) cmd.ExecuteNonQuery() but I get a syntax error: "S...more >>

hi, we run oracle here and i need the oracle component, so that I can use the oracleclient namespace. any ideas where it is ?...more >>

Is ADO .NET performance adequate for processing large volumes of data? For example, say you have a 500,000 customers with 700,000 orders a month. You want to identify trends over one year, so you need to scan over those 500,000 customers and 12 x 700,000 orders. During the scan, you're checki...more >>

Hello, I have been asked to write a program and allow the end user to create custom fields in a SQL Server database in addition to the premade fields. I understand how to add the column, the data type and such. My question is I need to accommodate the added forms in some sor...more >>

ExecuteScalar is great - it returns the first field of the first row. Is there a command that returns just the return value from the stored proc? I can't seem to find it. Thanks...more >>

Hi, I have a temporary table which contains around 2.7 million records. I am iterating through these records in a WHILE Loop and performing certain business rules on these records. Within the loop too i am using a large number of temporary tables. This entire processing is being done in a store...more >>

I have a form that is passed byRef a dataView which is can updated many times in the form. If the user decides to Cancel all the updates, I would like to be able to restore the dataView to its contents at entry to the contructor. Reject changes works fine in my form but causes other problems f...more >>

Hi. I need to raise a customized error message from a stored procedure in Oracle 8i and catch this error in my Try...Catches in VB.NET. Can anyone point me to an article or something that teaches how to do it? OTN site is terrible to find anything!!! Thanks, Robert Scheer...more >>

Hello, I am looking for a tool that will connect to the database and script the entire thing out (i.e. tables structured, stored procs, views, etc... including the data in the tables) to a file. I would then run this script elsewhere to restore the database. I'd prefer something that comm...more >>

Hi, I am using a DataRowView object that contains exactly one row. Here's my code: Dim dv as New DataView(ds.Tables(0), "City = 'Hammond'", "", DataViewRowState.CurrentRows) Dim row as DataRowView = dv(0) The row contains a column that can contain empty data. How can you tell if the s...more >>

Hi, I'm trying to make a little wrapper to execute sql commands with parameters. Execute("SELECT * FROM Table WHERE Stuff=@p1", somevar) Public Shared Function Execute(ByVal sSQL As String, _ ByVal ParamArray params() As Object) As Object [...] ...more >>

I have a program that creates an instance of a SqlDataReader via the Microsoft Application Blocks Data Access code. I use a typical try{} catch{} finally{} pattern for using it... <codesnippet> SqlDataReader rdr = SqlManager.ExecuteReader(/* yada, yada, yada */); try { while ( rdr.Read...more >>

First off, I think there is a bug in the Data ApplicationBlocks when it = comes to Output parameters. Even when I specify the direction the = SQLHelper.ExecuteReader method still treats the parameter as an input = parameter. But on to my questions... I am having trouble returning a values ba...more >>

How can one extract the Attribute values from a Dataset that has been loaded with an XML file like the following at the bottom of the document. I have to use a dataset and the XML file must remain the same? Regards, Ryan <?xml version="1.0" encoding="utf-8" ?> <Groups> <Group Name="...more >>

I have a C# Windows form with a datagrid. The datagrid displays a dataset. The dataset is created by reading an xml file. The dataset is read into an XmlDataDocument. The datagrid and the xml data will not sync when inserting new rows: When I insert a new row to the dataset by using Syste...more >>

Hi, I'm relatively new to ADO.NET and the issue that I'm facing at the moment is that I have an OleDbDataAdapter that JOINs two tables via the Query Builder. For example, I have two Customers and Bookings tables and I'm creating a CustomerBookings DataTable that contains fields from both Cu...more >>

Hi, I have a DataColumn that is specified as a decimal. How do you format the column so that the data has only two digits to the right of the decimal point (rounded to the nearest hundredth)? Thanks, Roshawn ...more >>

Second try asking this question - it's hard to believe that no one has come across this problem before of wanting to document the schemas used in their code. This seems like the kind of question that should have a simple and straightforward answer but I've found nothing. Original question a...more >>

Hello, I know this is probably a hudge topic to discuss and there are lots of different ways of implementation, but I still would like to ask and hear the most commonly used techniques for this. Basically I have an ASP.NET application, and my connection string currently is stored in a con...more >>

Hello, I have a question about the way ADO handles connections to the database. Let say method foo1() in ObjectA opens a connection to a database and before closing the connection it calls a method foo2() in ObjectB which also opens a connection (to the same database), and before closin...more >>

have soure something like this private SqlInt32 _Licni_ID = SqlInt32.Null; pomosna = new DataSet(); .... _MaticenLekar=Convert.ToInt32(pomosna.Tables[0].Rows[0]["MaticenLekar"]); The application works OK except when "MaticenLekar" returns null when i get error "Object cannot be cast from D...more >>

Hi ALL, there a lot of examples how to read data from CSV file, but I could not find any about how to save changed or newly inserted data back to the file. I tried to call method Update on OleDbDataAdapter which filled respective table, but debugger jumped out of the called function back to th...more >>

Dear friends I have a Table which is stored in XML. How to put the table to an Access database ? The access database is an empty database. which contains no tables . How to add the xml table to the Access database using ADO.NET ??...more >>

I've just read that I need to buy "DB2 CONNECT UNLIMITED EDITION HOST SERVER" so I can use a Web Server to connect to the DB2 at the AS/400 server. There must be some type of error because the licence costs 67,137 ?. The configuration is as follows (it's just an Intranet): 1) Operators w...more >>

Hi, I have the following code, which should allow me to only show a certain = number of items in a listbox: DataView dv =3D new DataView(dataSet1.Tables[ISSUE_TYPE_TABLE], = "IssueAreaDesc=3D'" + txt + "'","",DataViewRowState.ModifiedCurrent); types.DataSource =3D dv.Table; t...more >>

Hi!! Can any one help me get this info - Update individual cells in Excel using ADO.NET I keep getting error in the update statement. Thanks for any help in advance!! Here is my code - Dim connString As String connString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;" & _ ...more >>

Hi all, I'm currently working on a new solution that entails extracting key data from MS SQL Server (2000) and essentially export a dataset to an Access database. I may have been overthinking this but here's what I'd like to do: I have an XML representation of the MDB structure I need to bu...more >>

I am trying to find a simple way to determine the field size of a field in an Access table. I am writing in VB.NET Windows application. I would like a code snippet that I can get to work. I found some example on the Web but I couldn’t get them to work. I will be grateful if you can help me with th...more >>

My Update logic worked .. and now it doesn't. I went back, examined the stored procedure carefully, examined the table structure carefully, and examined the parameters collection carefully. All names, datatypes, and sizes match up. In this particular table, all values can be set to Null except f...more >>

I have three tables: clubListing, clubCollection and eventDetails. Being a newbie I am having problems in setting the relations. The clubListing table contains the fields clubID (primary key) and clubName. clubCollection contains no primary keys. It contains two columns, clubID (there can be...more >>

I am using the SqlHelper class from the Microsoft Data Application Block and had a question about returning an Identity Column. Basically, I have a form with a grid bound to a DataSet. The user can, for example, Add a new record. When they do this, and press Save, I call the ExecuteDataSet m...more >>

I'm building a dynamic command like this. "SELECT * FROM Clients WHERE FirstName LIKE @FirstName" and I set the paramater like this. sqlCMD.Paramaters.Add("@FirstName", "%" & fnameVariable & "%") The reason I'm doing this is I need it to search the whole field to see if it contains any of ...more >>

In Sql Server, I can use syntax to insert a record with default value: insert table1(a,b,c)values('A','B',default) But in .Net, if I want to use default value in Adapter.InsertCommand,for example, SqlAdapObj.InsertCommand.Parameters.Add(New SqlClient.SqlParameter("@testField")) SqlAdapObj....more >>

I am trying to create a document version management system using ADO.net and SQL server. I am storing the document in an Image field in the database. I could sucessfully implement check in , check out, undo check out functions but i am having one problem. When i check out a document , make some...more >>

Hi everyone, how could i update in datagrid & then update in the database??? Thx & Regards begin 666 smiley_doh.gif M1TE&.#EA$ `0`.8``/GRZ_;NY/GMWN[N[OGKV?GHT_CFS_CDR>3DY-[FWOGA MPOG?OOG;M?G7K?G4I=C8V.+2OO_,F?/0H_C+D?+,F_C*C]_1OOC)C?C&A<S, MS/''D_#"A?2_?/F^<_:Y:[#,T/&]>=>^GO>U:_FW8OFT6Z[...more >>

Is there any discussion on the availability of generic classes for ADO.NET classes to create strongly typed versions? We were able to create typed datasets easily but it was not easy to create a typed datatable "that could give a typed DataView" since DataView is what is mostly used for databind...more >>