a sql like: "select t1.a, t2.b from t1, t2 ...", how does ado.net handle the query result from this kind of sql? thx. hongyu ...more >>

Hello! I'm looking for a method to determine if the record of a SqlDataReader is the last. Basically I'm creating a hierarchical object tree with recursion. I guess I'm looking for a method like the With an old ADODB Recordset, you could simply use the following code: '## RECORDSET IS END...more >>

Before updating a datarow, its quite oftern for a data-bind form to check each control's data is valid first, before commit the changes on the datatable. I want to validate the current data row before it is updated to the datatable on a data-bind form. Is there any event for triggering such up...more >>

I'm using System.Data.OracleClient, it works fine when the user name and = password are correct. But when the user name or password is incorrect, it has a process = leftover in the oracle server box. There's no Oracle connection established, but the Oracle process is not = cleaned, and finally ...more >>

Oracle 8.17 Code as follewed : dim objCnn as OleDbconnection=new .... objCnn.open() objCnn.close() objCnn=nothing but the connection is still found by oracle ! How could i do? and driver providered by oracle. -- tiger liu ...more >>

Hi, I'm writing an application using an Access 2000 database. I am wanting to store the date and time of each record in separate fields in my data table. The problem is, what OleDbType do I need to use? There's Date, DBDate, DBTime, and DBTimeStamp. So, here's my table structure: Col1 AutoNu...more >>

I've two copy af the same asp.net application. The application enter on sql server, working with two separate databases (on the same sql server instance, of course). The connection is made with integrated security, and the server is a domain controller. If I start only the first application (c...more >>

my program want to modify a table with DataGrid control, the database is access2000 mdb format, after remove a row from DataSet (ex: myDataSet.myTable.Rows.RemoveAt(myIndex)) I add a new row to DataSet (ex: MyDataSet.myTable.Rows.Add(myDataRow)) when deleted row 's PK equ addnew row's P...more >>

I am using VB.Net 2003 Professional, .net Framework 1.1 writing a Windows Form application. My application requires that I provide an option to copy a set of data from a data table, change the effective data and at least one other item, and add this modified data to the data table. For exampl...more >>

I'm not sure this is the right place for this post but here goes. Using ADO we can obtain a dataset from Index Server using an OLEDB type connection. The query language is a subset of SQL but I cannot find any document that defines just how "sub" the subset is. Certainly the "BETWEEN" keyword ...more >>

hello Iam inserting a record (booking) into a database using the dataadapter.update method ..... is there any way fo getting the id of the last inserted record into the database with out writing an sql query ... is there anything in datasets ... i have to return the booking id of the inserted...more >>

VS 2003, vb.net, SQL MSDE... Using server explorer to create stored procedures, how do you put comments into the stored procedure (after the name would be the logical place)? Something like ' or REM don't work, and I cannot find anything in the SQL books on line that indicates how. I am just ...more >>

Hi everyone, I have problem with a connection to an Sql Server 7.0 (Mixed mode, using sql-login) from a development machine. Got this error message: SQL Server does not exist or access denied. Description: An unhandled exception occurred during the execution of the current web reques...more >>

Hi all i´m doing a vb winforms application, and in my app i´m using the wizards to create dataadapters, but when i create a new form with a new dataadapter VB allways create a new Connection. so my question is how can i create one single connection to the all app and still using the wizar...more >>

Question: Can I use SqlDataReader.GetString() to read DbType.Text field values that are larger than 8,000 characters? For example, if I decide to store a 256K ASCII text string in a column, will SqlDataReader.GetString() still be able to read it using a single call? Or, do I need to use SqlD...more >>

This is my first crack at ASP.NET and ADO.NET. I am making a page that will add/change/delete to SQL db using a DataGrid. I found a sample in a book that does the exact same thing I want using the Northwind db, but it doesn't work. The select, insert, and delete commands work fine, but errors...more >>

Is there a way to update an entire column in a datatable with out going row by row? ...more >>

Hi All, I have a problem with DataGrid. When I´m insert a new row, I can´t see it in the control, because the datagrid don´t move to last row. How can I go to the last row? Please I need help. Thanks! Jose ...more >>

Hi, I have a DataSet that I am using to bind to a combobox. I am trying to get the column name so I can use it for the display member. I am using the code below to get it, is there a better way? DataTable tbl = ds.Tables[0]; DataColumn col = tbl.Columns[0]; this.sizeComboBox.DisplayMembe...more >>

Hi, I'm trying to read a few values with tmp =3D SqlCmd.ExecuteScalar() If tmp =3D null (or in this case, System.DBNull), keep going, else, run = some stuff. I'm having a problem finding, and skipping fields that are null. I've tried the following: If tmp.GetType.ToString <> "System.DBNul...more >>

Is there a sample out there that uses datarelations with textboxes for both the parent and children? That updates, adds, and deletes rows from a database in SQL server 2000? That uses VB.NET 2003? That scrolls through the children (can this even be done in a winform?)? I know about t...more >>

I'm attempting to to use ADO.Net to execute a RESTORE DATABASE. Here is a snippet of the code I am using: SqlConnection connection = new SqlConnection(); string connectionString = ConfigurationSettings.AppSettings["ConnectionString"]; SqlCommand count = new SqlCommand(); SqlDataAdapter da =...more >>

Hi, I have created a datatable, dataadapter, added the table to a dataset and filling the table. Here I want to add an identity column to the above datatable and Later I will use this identity colum for printing the records using print document. How to create an identity column that inc...more >>