I have a combobox with a value field that represents a key in a dataset table that is NO bound to this combobox. In the SelectedIndexChanged event procedure I want to position the dataset table to the record with the key from the combobox. I can't quite figure out the right combination of meth...more >>

If I add a handler to the row changed event of a datatable, it fires when a row has been added, but when in the event, it hasn't actually added the row yet... Is there a way around this? How can I make sure that the row has been added to the dataset during this event? Or is there another one...more >>

Hi, I have a DataSetDataSource populated from an XML datasource. DataMember is assigned to one of the datasets in the XML file. I have a DataList which is displaying the DataSetDataSource. Any idea on how to get the DataSetDataSource inlcude multiple datasets within the XML files? Here is ...more >>

is there anyway to move a row from one data table to another with the same schema? ...more >>

I'm having a hard time deleting selected records through a datagrid bound to a view, VS .Net 03, SQL 2K is the back end although I'm not updating the database in the code where I'm having a problem. I am putting the selected rows into an array of datarowviews in the first loop, that is working...more >>

Hi all Should implement a transaction in both the stored procedure AND in ADO.net code or is doing it in one or the other good enough to protect against concurrency and atomicity problems? Thanks Simon "Mary Chipman" <mchip@online.microsoft.com> wrote in message news:8egpp052lm2jkk...more >>

I have an Access 2000 database with a table that has a field of type 'Decimal'. Precision = 5, number of decimal places = 2 My VB.NET application (FrameWork 1.1 SP1) has a strongly-typed DataSet for this database. The field within my DataSet is of type Decimal. I also have a DataAdapter to ...more >>

Hi, I just started reading about ADO.net, and the way I see it, there's no way I can automatically fill my Dataset with all the tables, and relations between them automatically, am I right? As far as I understand, I would have to know the structure of the (Access) database I'm accessing, and...more >>

Hello, I am attempting to retrieve BLOB data from an Oracle 9.0.2 Database. I ma using the GetBytes() method of the ODBCDataReader and am running it some issues with larger documents. The Code: Private Function RetrieveBlob(ByVal lngFormSeq As Integer) As Boolean '************************...more >>

Hi How can I install stored procedure programatically in SQL Server? Thanks Konrad ...more >>

Hi friends, There is a parameter (integer) for a stored procedure. I need to pass a value in my C# code, like the follows, System.Data.SqlClient.SqlParameter sp = new System.Data.SqlClient.SqlParameter("baseID", System.Data.SqlDbType.Int); sp.Size = 4; sp.Value = null; However, I got ...more >>

I am writing a SQL server table and Ole Jet dbf table. They are in a SQL transaction. However, writing dbf file (on network driver) sometimes halts and I must close the browser (or in VS.Net when debug). After that, the table lock of SQL server remains. I must go to SQL enterprise manager to ...more >>

I have downloaded some source code but I want this to convert the results into datagrid. dr = cmd.ExecuteReader() '**************************************** ' SHOW THE RESULTS '**************************************** sResults = ...more >>

I have a DataGrid with edit and delete buttons bound to a record set. I have added code to remove records from the record set and re-bind to the data grid when then delete button is clicked. This works fine. I use GetChanges to get the records for writing to the database and it comes up null....more >>

Hi, I have a simple query with an inner join: select A.Field1, B.Field1 from A inner join B on A.Field2 = B.Field2 when I read the values with an oledbdatareader accesing a SQL Server database (reader["Field1"]) return the value from the table "A", and i can't read the value in the table ...more >>

Hello, I am trying to create an instance of the ADODB.Command object using javascript on one of my webpages. var oCon; var oCmd oCon = new ActiveXObject("ADODB.Connection"); oCmd = new ActiveXObject("ADODB.Command"); The oCon creates succesfully, the oCmd returns an unable to create ob...more >>

I am using dataconnections/dataadapters but I don't want to tie my application down to a specific database. It seems as if I MUST use a specific connectionstring when defining my dataadapters. This does make sense but then how do I move this application to another site that has a different SQL...more >>

How do you select records from one dataset and create a second dataset? I need to pull out the master records from a dataset and create a master datagrid in which to embed a details datagrid (for a master/details type report). -- Thank you kindly, Dan Sikorsky BAB, BScE, MSC ...more >>

I am writing a database front end windows application in C#. I need to allow a user to select a database to connect to at run time via a standard dialog box. This is easy in Visual C++ 6.0, all you have to do is #include atldbcli.h and then call the CDataSource class Open() method with no ...more >>

Hi. I know how to use a SQLDataAdapter to execute a query and return a dataset. For example... SQLDataAdapter.Fill(DatasetInstance, "StoredProcName/TableName") But could someone please give me an example of how to execute a query and return a dataset using a SQLCommand? SQLCommand doesn't...more >>

as title said , I run code below , the column(a1ap6d1.in_seq) from subquery could not return basetablename but null I realize that using join syntax could , but subquery is popular syntax , is there any way to get correct basetablename when a query contain subquery? Dim rdr As SqlDataRea...more >>