I have to insert to my database's table around 200 items. Actualy, for each
new item that must be inserted an SQL stored procedure is invoked.
The stored procedure does some tasks and then inserts the item into the
table.

I am designing / implementing a thick client application in C# which will draw in a large quantity of real time data from various external feeds (Tib and similar mechanisms)
cache data in an in memory database and display data in a variety of configurable controls on an MDI front ...

I am quite inexperienced in databses so I just wanna ask that how can we add
data to junction table after adding data to the Parent Tables.
I have Three Tables:
Topics  --->      TopicsQuestions  <----      Questions

Is it possible to run 2 commands within a try-catch statment with a datareader
i.
          Tr
               Cn.Open(

How can I get SqlDbType of a column in a table in SQL server database?
Parameters:
1. SqlConnection
2. TableName As String

I have a 5 way table join that returns values I need to update
solutionSpecId, solutionId, decisionSpecValueId, specHeading, specDescription, and spec
I'm updating the SolutionSpecs table and it has solutionSpecId as the primary key
solutionId, decisionSpecValueId, and spec are also ...

I am working with C#, SQL CE and ADO.net using the .net compact framework on a PDA
I need to populate quite large tables from XML
Initially I just used Dataset.ReadXML but this quickly ran into memory problems with large amounts of data
I am now using XmlTextReader to read the data ...

I'm testing MySQL-database version 4.0.18, which contains table column
'ArticleNr' and data type is varchar length 40.
Connection is made using ODBC ConnectionString like ...
"DRIVER={MySQL ODBC 3.51

Why am i not getting a match with this search:
string sql = "select ... from ... where somedate = @fd";
cmd.CommandText = sql;
cmd.Parameters.Add(new SqlParameter("@fd",System.Data.SqlDbType.DateTime));

A simple question.
Could somebody give me the exception name for a duplicate index, primary key or relationship. It'd be something like DBConcurrencyException.  It'd be DB?Exception.  Please help.
polynomial5d

This KB article describes a fix for a problem ("by design"!) using
SqlDataAdapter.Update followed by a DataSet.Merge:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q313540
The problem addressed is: The default behavior of SqlDataAdapter.Update sets

I understand that I can download the Oracle.Net provider from Microsoft and
I also understand that Oracle has one as well.  It would appear that if I
am using 8I version of Oracle, that I will not be able to use the ones
create by Oracle.  Does the microsoft version work with 8I, ...

I'm having a problem reading from a SqlDataReader accessing SQlServer 2000.  Part way within a while ( Read() ) loop, I get an exception with the message "Invalid attempt to read data when reader is closed."  However, no where in the code is the reader closed.  I've tried ...

I have run into this issue a number of times.  I have complex parameterized
commands that I am running against an access database.  When I get errors
there seems to be no way of seeing the actual SQL statement that is being
run against the server-- i.e., the parameters are replaced ...

Is there a way I can expose the metadata from sql server of a database in a
well defined XML format that sql server can supply to me? I dont want to
write xml schemas myself and fetch the metadata and adapt the information to
my schema - id rather just get a xml stream and I can ...