| Thread | Last Post | Replies |
|
| Parsing DataTable Columns | 05 May 2005 22:46 GMT | 3 |
In my DataTable the following data is returned Object_IDX Object_FullName 48984232 |MS_Net|EUR|Server02 48986409 |MS_Net|EUR|Server21
|
| DatGrid Problem | 05 May 2005 21:55 GMT | 2 |
I am trying to display an Excel file in a DataGrid. I have Included my code. It runs through with no exception, but nothing appears in the datagrid Code: Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As
|
| Filling multiple tables in Dataset | 05 May 2005 21:12 GMT | 5 |
I know this has been asked several times before, but... Q: How can I fill multiple tables in a Dataset using a SINGLE .Fill? Assume I have three tables in the data source - T1, T2 and T3 - that are related "hierarchially" by FK's: T1 <--FK T2 <-- FK T3 The keys are
|
| New System.Transactions Namespace | 05 May 2005 18:04 GMT | 2 |
If I develop a component A and create a method DoSomething(string connectionString) and I have another component B with a method DoOtherThing(string connectionString) and from inside DoSomething() the B.DoOtherThing() will be called like
|
| DataAdapter is not using correct connection string | 05 May 2005 18:00 GMT | 3 |
I'm hoping that someone out there can help me out of this. I'm having several DataAdapters which are referencing all to the same OleDbConnection object. At construction time of my DAL component, the connection is instantiated (but not opened yet) and given a connection
|
| accessing table names per DSN | 05 May 2005 17:29 GMT | 1 |
I have list of DSNs (for Access, Excel, SQL Server, Oracle or any other databases) I want to connect to any of the DSN and display the available tables per DSN in the combo box....
|
| how to export dataset to sql or access | 05 May 2005 16:42 GMT | 2 |
This question is similar to one asked previously, but I'm wondering how to automate the process. My program queries a custom library object which returns a DataSet result. The library is configured to act as a method for querying databases (sql or
|
| No Schema Wanted with Data Adapter | 05 May 2005 16:41 GMT | 2 |
Using batch SQL statements that return multiple results. Dim ds As New DataSet Dim cmd As New SqlCommand cmd.CommandText = "SomeStoredProcedure"
|
| Generating Typed Dataset from XML Schema | 05 May 2005 13:30 GMT | 1 |
I am trying to generate two datasets from xml schemas, but when I generate the second one it overwrites the first one, as i dont seem to be able to specify the dataset name. Can anyone help ?
|
| Unable to display child rows | 05 May 2005 10:50 GMT | 7 |
I created a dropdown list and a datagrid in a webform. When a customer's name is selected in the dropdown list, a "SelectedIndexChanged" event is raised and the orders for that customer would be displayed in the datagrid. The following code was written but the orders were not ...
|
| Using DataReader | 05 May 2005 09:22 GMT | 1 |
After I execute my datareader, say for e.g. Reader = dbCommand.ExecuteReader, I can do a while loop to retrieve the results, like this: While Reader.Read() Result = Reader.GetString(0)
|
| Write Multiple Blobs to Single Record | 04 May 2005 22:17 GMT | 1 |
My following code creates two records. How can I combine this code to not only write both blobs to a single record but to ALSO write a another normal string field to the same record (not inserted yet). Help on either would be greatly appreciated!
|
| Find DataViews associated with a DataTable | 04 May 2005 18:11 GMT | 5 |
Is there a way to find all DataViews associated with a DataTable? I have a method which sort of refreshes the DataTable property by assigning a DataTable to the field the property points to. The problem is there are some forms open that are using the DataTable in a DataView and ...
|
| Returning Multiple Recordsets, print statements and errors? | 04 May 2005 17:51 GMT | 4 |
if I execute the following proc I can get the first recordset 2 print statemts and 1 error, but 1 of the print statments and 2 recordsets fail to show.. Is this possible in ADO.net (Query Analyser has no issues with it....)
|
| Important -> MDAC and XmlDataDocument | 04 May 2005 16:49 GMT | 3 |
I have a windows forms application and , what I basically do is: 1.- Instanciate a DataSet. 2.- Instanciate a XMlDataDocument attaching the DataSet to it. 3.- Load XmlDataDocument with a local XML document (C:\mydoc.xml)
|