all groups > dotnet ado.net > november 2004 > threads for tuesday november 23
Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30
how to find dropdownlist selectedvalue in dataset datatable to update foreign key in another table
Posted by ambersaria420 NO[at]SPAM yahoo.com at 11/23/2004 6:03:32 PM
Hi all,
Here's scenario:
Table 1:
Table1_pk
A
B
C
Table2_fk
Table 2:
Table2_pk
A
B
C
I have dropdownlist on a webform which selects value B from Table 2.
When I select a value from the dropdownlist, I need able find
Table2_pk for that selected value and insert into Table2_f... more >>
ASP.Net - Access 2003 - Large BLOBs
Posted by Rich S at 11/23/2004 4:25:03 PM
Working on C#/ASP.Net application in which we are storing secure, private
PDFs, Excel Spreadsheets, Videos, and Images in an Access 2003 database. We
have not yet upgraded the database to SQL Server as it is still in the
development and testing stages.
Unable to utilize administrative webf... more >>
Database BLOBs with OLE wrappers
Posted by steve8man at 11/23/2004 4:15:03 PM
I have a web application where users can upload JPG image files which I store
as BLOBs in a SQL Server database. This works fine in general. However, I
like to use MS Access to browse and occasionally manually update the database
for administrative purposes. The JPG images do not display in... more >>
How to Spit Dataset
Posted by Niraj Ranka at 11/23/2004 3:20:19 PM
Hello,
Can anyone please let me know, how can i split the dataset into two
datasets... based on some condition.
Thanx in advance
Niraj Ranka
... more >>
DataSet.ReadXml - where the schema name is?
Posted by RA at 11/23/2004 11:39:49 AM
Hi
I have an xml schema and I have created a dataset from that schema.
I have a web service that recieve info and sends back an xml information.
I send back the xml using SchemaDataset.WriteXml (...)
A consumer of the web service then call a different method of the web
service which takes an ... more >>
ADO.NET 2.0/Sql Server 2005 suggestion
Posted by Sahil Malik at 11/23/2004 9:39:57 AM
I have no alternate way of reaching the MS product team, so I am using this
newsgroup - hopefully the MS gods will pick it up from here.
The suggestion is - UDTs are a very useful feature. However the rules
surrounding the Format.Native, vs. Format.UserDefined are way too hairy.
They are under... more >>
I need as/400 DB2 .net data connector
Posted by Scott Emick at 11/23/2004 9:19:00 AM
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?
Thanks,
Scott
--
Scott Emick
Web Programmer
Fox International
Remove the ham from ma... more >>
How to tell which kind of exeption it is?
Posted by Andrew at 11/23/2004 9:09:08 AM
Hi, friends,
We have a common exception log function in C#:
public void LogException(System.Exception e)
{
.......//write error info to a file
}
which will log error message into a file. Sometiems, SqlException thrown
when using ADO.net will also be passed into this functio... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
DataReader skips records??
Posted by MN at 11/23/2004 6:29:16 AM
Hello all -
I'm at wits end with this and I'm sure I'm doing something wrong but can't
figure out why. I have this loop below.
'OldPlayersReader skips (1st to 3rd to 5th)
While pastDeadlineReader.Read And oldPlayersReader.Read
If oldPlayersReader Is Nothing Then
... more >>
Update DataTable with unique index using DataAdapter
Posted by CribGoch at 11/23/2004 2:23:03 AM
Hi
I am having a problem updating a DataTable that has a unique index on an
editable column.
For example, say there is a table with an integer field called [Value] that
has a SQL unique index. This column is in addition to the primary key.
Say that the table has five rows with values:-... more >>
read ADO adPersistXml recordset into ADO.NET Dataset?
Posted by arvee at 11/23/2004 12:54:40 AM
I have an older application that provides a table in the old ADO
disconnected recordset format. For example:
- <xml xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882"
xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882"
xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema">
- ... more >>
|