I'm working on an ADO.NET project. I'd like to declare a Common Variable that can store the Connection String values for a Database. I need this variable to be able to initialise the database connection for all OledbDataAdapters across all Form modules. Thanks! ...more >>

hi. I cannot retrieve an output parameter from a stored procedure by name. Is this correct? Works not: [ sParamValue = mycmd.Parameters["@ID"].Value.ToString(); ] Works fine: [ sParamValue = mycmd.Parameters[0].Value.ToString(); ] TIA /OF ...more >>

I have an ADO.NET connection to an Access 2000 DB with 1 table. I have a Data Grid that shows me all records when I open the Data Grid. In the program it shall be possible to add rows to the table directly in the grid, by adding rows. Have tried to code this, but the result is only an empty ...more >>

Hope somebody can help... I'm trying to load up a text file using ADO.net, as follows: Dim TextConnectionString As String TextConnectionString =3D "Provider=3DMicrosoft.Jet.OLEDB.4.0;" & _ "Data Source=3D" & FilePath & ";" & _ "Extended Properties=3D""Text;HDR=3DNO;FORMAT=3DDelimited""" Di...more >>

Hi When I drag a table onto a dataset from the server explorer I get a Data Adapter Configuration Error...'Error in SELECT clause: expression near "".....'. How can I fix this? I am using FoxPro tables. Thanks Regards ...more >>

I have an ASP.NET/VB app that updates values in a DataTable over the course of about 3 different pages. On the way out of the first of these pages, I explicitly build the DataTable from values in a DataGrid, and set the PrimaryKey of the DataTable to be the first cell in the grid (which is a Us...more >>

After aborting a long (around 10 minutes) and with numerous updates, the Rollback function will raise an exception giving the message: System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. -- at Sy...more >>

Hi I have several tables in a dataset. How can I reread the data from underlying database in only one of the tables? Thanks Regards ...more >>

I am using Visual Studio .Net 2003 Server Explorer to make any changes to my SQL Server 7 Database that is local to my machine. I also have SQL Server 2000 running on my machine and have recently upgraded the database to SQL Server 2000. Unfortunately I don't seem to be able to make an...more >>

Hello: I just started looking into ADO .net, and I wonder if it works well in production environment. One of the questions I have is working with multiple tables with ADO .net; that these tables are related. If there are update, insert, delete to the dataset returned from the database. When ...more >>

Can someone tell me what is wrong with this code? I am simply trying to = add a record to a database. The error message is as follows: An unhandled exception of type 'System.InvalidOperationException' = occurred in system.data.dll Additional information: Update unable to find TableMapping[...more >>

Hi, I have a problem. I have no any clue about this. Please help me to figure it out. I have a Customers table and Orders table. There is a relation,named "Customer2Orders", between Customers (parent table) and Orders (child table) on CustomerID. One Customer may have multiple Orders. ...more >>

Hi, I'm planing to have a form with 10 bound textboxes to a dataset throgh the currency manager and bindingcontext. What I need to do is use that same form based on the user choice. He/she could first press a button to fill-out all textboxes from dataset and do normal navigation through all...more >>

Hello ! I'm trying to make a link between two Access databases. Actually there are a few Tables in one of them I want to attach to the other (attach or add) knowing that the schema of the tables changes depending of which database is opened in the first place. Consequently I can't write a SQL ...more >>

I have an xml file that is currently being used ... I need to make the xsd file for it for intellisense to work in the .net ide. So, when I try to do the xsd file, it keeps giving me an error about the tables being nested and are wrong...so after looking and sifting through google, I'll try he...more >>

I have several datatables that are of the identical schema, each holding different data. There are times when it would be nice to combine the data from two datatables into one datatable. Would prefer not having to do this through looping. What would be the best way to do this? ...more >>

Hi, I just wanted to ask what is wrong with this stored procedure. i keep getting the following error message: ADO error: The column prefix 'dbo' does not match with a table name or alias name used in the query. ALTER PROCEDURE dbo.SPSelEquipBooked2 (@Arrival datetime, @Departure da...more >>

How can that be? Isn't it supposed to return dbnull if there is nothing in the select? Ronen ...more >>

I am using the following code to apply the databinding format for Date (04/12/2003) **********************CODE***************************** Private WithEvents DateBinding As Binding DateBinding = New Binding("Text", Me.DsReport1, _ "Report.Date") Me.RichTextBox.DataBindings.Add(DateBindin...more >>

Is there any kind of FIND in ADO.NET that works the same way as the old ADO Recordset FIND? The old ADO Find would accept a criteria string, and then find the first record that matches the criteria. For instance, rs.Find("text_value like '* | *') would position me on the first record that c...more >>

Hi all, Does anyone know the syntax for returning a value from a user defined function in Sql Server using VB.Net. Each time I do it I get: invalid object name We have a function which takes one parameter and returns a table. I can find little or no documents directly addressing th...more >>

I want to redo my Forms in VB.NET. Now when I go and test my Forms to make sure they work I want to set up a second ACCESS file as a test database. When everything works and I want to switch over to my Production database how would I do that? Would I have to go into all my VB forms and red...more >>

Hi, I'm using OleDBConnection to read data from Excel. I'm able to read everything except when a cell has numeric value and the column has alphanumeric data. I get DBNull when it encounters a numeric value. I'm sure many people have seen this. Does anyone know how to address this is...more >>

Hi, Does anybody know how to set the parent row of a child table's row to a detached row? I'm using Forms DataBinding. If I add a new row for editing, using BindingContext(someDataSet,"ParentTable").AddNew() the row's RowState is Detached. Now, if I try to add any child rows to a child tab...more >>

Does ADO.Net work with SQL Server 7 or is it only compatible with SQL Server 2000? Thanks in advance Chris Pearce...more >>

I'm trying to use an OleDbConnection to read some data from an Excel Spreadsheet. I create my connection string, and open the connection, but when i query the sheet/table i get the error that OleDb could not find the sheet. I've now tried to get a list of the sheets (to see if i was using the ...more >>

We have been using the same sproc for an insert for quite some time. The sproc create a new key for the record to insert, uses the key for the insert and then has an output param for the key. The key field in the DataTable is 'names_id'. The is the sourcecolumn for the sql output param. Yes...more >>

Hi, i have a DataSet with 3 Tables. For each table i have defined a SqlDataAdapter Object. The SqlCommands for Deleting, Inserting und Updating were created by the SqlCommandBuider Object. I have wrote the following Code, to write the Content DataSet. public void WriteData() { Sql...more >>

Using VS.2003 and ODBC I make a SELECT count(*) from table1. with ExecuteSQLSelect This must return always !!! a number-value . But if I try to read from the datareader with GetInt32 a get always a inValid cast operation exception . Only Getstring(0) works fine. Is there any solutio...more >>

Hello, Have a datset returning a null value in a text string and crashes app. Used article 318039 as a guideline to modify dataset.xsd. (part of a WebService) Still Get Null. Excerpt follows. <xs:schema id="MASpedDataSet" targetNamespace="http://www.tempuri.org/MASpedDataSet....more >>

I have a select stmt as follows SELECT qty, qty * 2 AS qty1, qty + 10 AS tuir FROM sales I have to bind table values which I obtain by running the query to a datagrid (web control)Item template column How should i give the expression for my datafrid columns ? ...more >>

Greetings, I would like to know please how can I create two xml files from one dataset with two tables in it? The WriteXML method of the DataSet creates one XML file with BOTH tables of the dataset. Dim ds as new dataset Dim da as new dataadapter 'code goes here for declaratio...more >>