I get this message when executing SELECT statement in SQL 2000: Location: recbase.cpp:1374 Expression: m_nVars>0 S PID: 51 Process ID: 2480 Why? Any help? ...more >>

I try to make a connection with an access database using jet 4.0 OLE DB provider and i receive the following messages: "Test connection failed because of an error in initializing provider.catastrophic failure" and/or "An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred ...more >>

Our old COM data access components use ADO. As we are now begining to move to C#.net, we would like any new data access components to use ADO.net. Therefore we will end up having two seperate connections: One ADO connection and one ADO.net connecation. Is there any way of making it so t...more >>

Hi, It seems I ran out of clues. This is the situation: Win98se client with Windows.Net Application (framework 1.1, MDAC2.8, Jet 4.0 Service Pack for Win 98) and the following connection string: "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\archive\db\app.MDB;User Id=admin;Password=;" ...more >>

I'm working on my own implementation of an ADO.NET Data Provider derived from IDbXXXX classes and MSDN sample (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconImplementingNETDataProvider.asp). All is fine when I execute simple Command and DataReader but I got an...more >>

This is probably a stupid question but its been so long since I've had to do it with ADO, I can't decide which way to do this in ADO.Net. I have basic stored procedures (SQL 2000/MSDE) that do inserts, updates and deletes. I call these from an SQLDataAdapter Update/Insert/Delete -> Update c...more >>

Hi, Im trying to create a connection to A database in Visual Studio.Net. I select Tools->Connect to Database. Nothing happens. Im trying to connect a data source to my datagrid, but not even able to connect to the database I want to. Any suggestions will be appreciated. Thanks. ...more >>

Hi! I want to extract a single row from one table in a typed dataset (dsUser) containing multiple tables, and then send it on to a data access layer component for create/read/update/delete operations. I found two ways: 1. Create a standalone typed dataset (dsPerson) with the same structure...more >>

Can a DataSet be used to update a database if the query that originally populated it had table and field alias names in it? ...more >>

This may not be in the correct place, but I am getting desperate. I am trying to get the field @FileName using vbscript. The store procedure looks like this, and I have already tried putting @FILENAME OUTPUT below the declarations and I received an error. if exists (select * from sysobje...more >>

I'm trying to filter a DataTable... first I do a SELECT on my DataTable... and assign the result to a DataRow array... then I CLEAR the DataTable... and try to import the DataRows from the DataRow array... I end up with an empty DataTable... what am I doing wrong? And... is there a better way...more >>

If I base my DataSet on a schema (an .xsd file), and then bind the controls on my form to the necessary fields in a DataTable in the DataSet, how then would I use the SqlDataAdapter to put all this information into the database? Loading the DataSet from a schema is easier than basing it on ...more >>

guys i have a very simple question concerning the differences between the two. for instance, radio buttons and the checkchanged event. it really doesnt seem to respond in asp.net if i set an if statemtent in that control, where if checked = true, then one thing happens, or if checked = false ano...more >>

Everything I've read says the below code should update the foxpro table, but it doesn't. The dataview and datagrid are being updated, but the actual foxpro table isn't. The table has 3 fields ( idnum, fname and lname). The select statement gets the one matching record just fine. The recor...more >>

I have a stored proc that returns me multiple tables. Is there a way I could set their names to be something other than TABLE TABLE1 TABLE2 ... ?? Sorry TableMappings won't do !! I can't use that for certain reasons. I have to be able to do something in the T-Sql that after SqlDataAdapter.Fil...more >>

Hi Guys, Have just downloaded v2 of the Data Access Application Block but see that v3 is available on the GotDotNet website. Does anyone know: if v3 is stable enough for use in real systems and when Microsoft are likely to release it officially. Cheers, Peter ...more >>

Hi guys, I need to know how to create child rows for a newly created parent row. I've been doing it one way, but it's obviously not the right way to do it (finally starting to cause me some problems!). Here's what I've been doing ("ParentID" is the primary key): \\ Dim NewParent as Dat...more >>

I have a dataset that reads from an xml file. When the file was read, 5 tables where created.having the relationship between the table. how can i merge those five tables into one table or better yet how can i make that table relational? thanks ...more >>

I need to insert NULL into the field with SmallDataTime datatype. In .NET when I tried to use "" or DBNull.Value it insert "" what will be automatically converted into '1/1/1900' by SQL Server... I need to have the Insert statement like this: INSERT tblTest (Name,smDate) Values ('John',NULL) Bu...more >>

Hi everybody, this is my first post in this group. I'm working with an Access DB and i have the following code to validate fields with unique indexes (no duplicates): 'Field is a DataColumn If Field.Unique Then If Field.Table.Rows.Contains(NewData) Then Re...more >>

Hi All!!! Seasons Greetings.... I have read a lot of the post regarding CommandBuilder, InsertCommand and Update. The code below works.... 'This is a foxpro table that matches my MS SQL Table fpDA = New OleDbDataAdapter("select * from table", GetConnection) flat = New System.Data...more >>

I have 2 tables: Table: UserTable Field: Id (pk) Field: FullName Table: MarriageTable Field: MarriageId (pk) Field: Husband Field: Wife The MarriageTable.Husband and MarriageTable.Wife fields BOTH have to be valid users from the UserTable. In SQL Server I'm creating a relationship...more >>

Can somebody please help. I'm coming from VB6 and this is my first VB.NET applciation. Below is my code that fills two tables contained in a DataSet, creates a relation between them, and finally, uses them as DataSources for two grid controls on the form. This code works prefectly fine. Now, ...more >>

Hi all, I want to check if a record exists in the DB. I use two different ways to create the sql query. One way is by using SqlCommand and SqlParameter. The other way by building the query myself (without SqlParameter(s)) and using the SqlCommand to execute it. In one I get false in the other ...more >>

Hi all, I want to check if a record exists in the DB. I use two different ways to create the sql query. One way is by using SqlCommand and SqlParameter. The other way by building the query myself (without SqlParameter(s)) and using the SqlCommand to execute it. In one I get false in the other ...more >>

hey guys, i need some help on an approach. i need to compare, two different lists. one will be pulled from a dataset and could have as much as 2500 varchar employee numbers in it. the other will have the same data, but might be missing some of those same numbers. what's the best way to compare t...more >>

I am trying to make sure I'm using best practice for an Access table. If I have a table that has 100 discrete colums. Is it best to just keep the table with so many columns or to split it into a few other tables. The 100 columns are indeed discrete so splitting them isn't going to reduce an...more >>

BlankHi, I select a value in a bound combobox on tab 1, then I programically assign related text to a bound textbox's text property on tab 2. I see the text in the textbox when I view tab 2 and the textchanged event fired. However, after I save the changes, close the form, reopen the form, the...more >>

Any way in ADO to get to the Description of the field - for example, in Access you can provide a logical description for each field in the table. Thanks, Scott ...more >>

Hi, I'm trying to update the Database (sql2000) using the DAAB v2.0 SqlHelper.UpdateDataset method. The problem is that my insert stored procedure returns the primary keys of my new inserted rows as a returned values parameters. But with the above method there seems to be no way to get back...more >>

I am using a datagrid to write data to the database. I am using the walkthrough by msdn "Using a datagrid to Read & write data to Database". But when i hit the update button I get the following error: : Object reference not set to an instance of an object. Description: An unhandled excepti...more >>

The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data. Is the error message I get when it gets to dbCmd.ExecuteNonQuery();. I have 15 fields to insert, therefore I did one field at the time and found that the 13th field is the one causing ...more >>

I am passing an ADODB.Recordset (rs) into a .Net C# dll. I need to fill a dataset using Oracle.DataAccess.Client.DataAdaptor. OracleDataAdapter da = new OracleDataAdapter(); DataSet ds = new DataSet(); DataTable dt = new DataTable(); da.Fill(dt, rs); This does not work. I need to use:...more >>

Anyone who knows how to fill more than one datatable in a single fill using a dataadapter? I have 4 joined tables in a select-statement that I want to fill into their datatables. Now I have to make 4 selects to do that, and that's no good. Alternatively make a datatable representing all 4 tabl...more >>

I have a situation where I have two datasets each equal with the data from the same table. I want to update one dataset with the records from the next dataset IDs in tact. Here's the code I have: ' Set AcceptChangesDuringFill = False objDataAdapterSource.AcceptChangesDuringFill = False ' Fi...more >>

Is it possible to add a column to an existing DataTable (in a DataSet) with the new column being some place other than the end of the column collection? I looked at Columns.Add and there is no position parameter and there is no InsertAt method like some other collections. Is this possible ...more >>

I am posting this question here too coz I was not sure whether I had posted this earlier in the right group. I need an editable datagrid. But for editing a datagrid as shown in the walkthrough: Using a DataGrid Web Control to Read and Write Data, the table in the SQL database should have a...more >>

Hi, I am using the ExecuteReader method from the Microsoft DAAB to return a DataReader which I am iterating through to mainly read a binary value from one of the returned columns. I am using this value as the raw data to render a PDF document. After this is successful, I want to update the ...more >>

I am trying to execute several DML statements in a single call to an ADO.NET SqlCommand object, ie. update table1 set column1 = x update table2 set column2 = y I am wanting to get the rows affected for each update statement, ie. 10 rows for table1, 20 rows for table2, but the RowsAffected o...more >>

In VS.Net Server Explorer, you can drill down to a SQL Server store procedure and finally, it diplays not only parameter of the procedure but also the result columns. How can I replicate this behaviour in my application?...more >>

I've been working on the Mono Sqlite 2.x client (http://www.go-mono.com/sqlite.html) in order to make it work with Sqlite 3.0. Note that I have nothing to do with Mono, but I find this code useful for working with Sqlite in Microsoft .NET. I'm wondering what would be the best way to name the...more >>

I want to update MultiDatabase with Microsoft's MSDTC.Just like ADO.Net provided, I designed an interface below: public interface IDistributeTransaction { int StartTransaction(); int CommitTransaction(); int RollBackTranstion(); int ExecuteSql(string connectionstring,string Sq...more >>

I'm using connection pooling (0 min/100 max) in an asp.net web application. All users log in using the same connectionstring. Is it prudent, for instance, to close and dispose of my connection after a database update takes place which I normally do when I'm not using connection pooling?...more >>

Hi I have an ASP.NET application. I am using a dataset for loading data (based on user input month & company Name) from SQL database. I have the query as :: SELECT CompanyName, Date , CEO from TABLE WHERE (CompanyName=@a && But how do I get the month part from the Date field in the datab...more >>

Hi, Our database is constantly updated (input data) from another DB, and sometimes it crashes our ASP.NET applications. My boss told me to write a DB utility app to check DB and make sure all apps are still running. The first step of few checks is to compare current DB tables with yesterda...more >>

Does System.Data.OleDb.OleDbLiteral have a purpose or is it just there to look good, as if it is used by something when it is not, or will be used in something in the future ? ...more >>

Hi, I have an ASP.NET application. I need to read records from the SQL database based on a value entered by the user. I need to get the result in Text boxes. I am using DATA READER for this. But how can i view the next record from the database in the text boxes?? I get one record in th...more >>

Hi, how can I list the following things with ADO.NET in a generic way: a) list all databases available in a DBMS b) list all tables within a selected database c) list the fields (and their type, constraint etc.) with in a table I've found things like GetOleDBSchema.. but (of course) it is...more >>

hi, i use ado.net to call a stored procedure in SQL Server 2000. the SP have a parameter that is input and output when i send an input value of null, the return value does not return correctly and i get null in return even if the SP set the value to something else. if the initial value i...more >>

Hi, I am new to web programming and am using ASP .NET (C#) and ADO .NET to develop a web based room booking application. I have been reading a lot of books on ADO .NET and ASP .NET and I have a few basic question which I am totally confused about. Please note that I am a beginner and you ha...more >>