| Thread | Last Post | Replies |
|
| Setting and using relationship between XML and SQL | 31 Dec 2004 21:48 GMT | 3 |
I am having a problem with my relationships (Not personal ones though :-P) I have an XML datasource and a SQL datasource. I have put them both into the same dataset.
|
| Returning error from stored proc | 31 Dec 2004 21:20 GMT | 3 |
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 ...
|
| I need as/400 DB2 .net data connector | 31 Dec 2004 21:10 GMT | 4 |
Where can I get it? The links on the IBM site all appear to be broken. The .net provider that comes with DB2 for windows does not allow one to connect to as/400 either. Anyone have any ideas?
|
| Filtering a DataTable | 31 Dec 2004 19:49 GMT | 2 |
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 ...
|
| REGDB_E_CLASSNOTREG(0x80040154) -> What else to do? | 31 Dec 2004 14:13 GMT | 3 |
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
|
| DataSet binding/updates | 31 Dec 2004 10:22 GMT | 2 |
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?
|
| ADO unable to get values | 30 Dec 2004 22:38 GMT | 2 |
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.
|
| Northwind ReportsTo NULL ComboBox | 30 Dec 2004 21:39 GMT | 9 |
I'm trying to show the ReportsTo field of the Employees table in the Northwind database in a databound ComboBox. This works fine, except for the case where ReportsTo is NULL. When ReportsTo is NULL the ComboBox should show an empty string, or whatever, but it shows the first item in ...
|
| DataSet/field alias | 30 Dec 2004 21:08 GMT | 1 |
Can a DataSet be used to update a database if the query that originally populated it had table and field alias names in it?
|
| ASP.NET vs VB.NET | 30 Dec 2004 19:12 GMT | 4 |
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 ...
|
| Display Byte[] Array in DataGrid | 30 Dec 2004 17:19 GMT | 2 |
This has probably been asked before but my searches are not coming up with anything. I have this DataAdapter mapping a table and using a DataGrid to display the contents. I update a varchar field - and this data shows up fine. I have a timestamp field on the server side, and ...
|
| Named tables/Sql Server/Can't do TableMappings | 30 Dec 2004 16:33 GMT | 3 |
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 ...
|
| Different results with the same query?!? | 30 Dec 2004 14:29 GMT | 1 |
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))
|
| Child rows | 30 Dec 2004 13:39 GMT | 4 |
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):
|
| Different results with the same query?!? | 30 Dec 2004 08:42 GMT | 4 |
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))
|