Hi All, Is it possible to have more than one data reader in a single connection (MSDN documentation dated July 2002 says that to have more than one data reader, there should be more than one connection, one for each data reader.) http://msdn2.microsoft.com/en-us/library/ms971481.aspx has ...more >>

I'm getting a SYNTAX error in this statement: INSERT INTO Usenet (MessageID,Subject,ArticleDate,From,Lines) VALUES ( '<131prkkuk51ed5@news.supernews.com>', 'TG FM - The Eternal Candle - "eternalcandle_v.1.1.zip" 22716KB yEnc (08/37)', '4/11/2007', 'None@none.a (Sxerks)', 5082) I believe...more >>

I am trying to use a lightweight transaction to encapsulate multiple sqlcommands on a connection (they update different databases in the same named sqlserver instance) so if one update fails they will all roll back. My development system is XP Pro and when I try to test the below code I ge...more >>

If I have a typed data set with columns ColumnA and ColumnB (both strings) in a table, I was thinking that I could do something like this Partial Public Class TheTDS .... Partial Public Class TheDataTableRow Private ReadOnly Property ConcatenatedColumn() As String Get ...more >>

Hi; I get this error randomly on both my home and work computer. I'm hitting Sql Server 2000 dev version on localhost. This happens on both my home and work computer. Here's the exception: System.Data.SqlClient.SqlException occurred Message="Timeout expired. The timeout period elapsed...more >>

I've been using the VS 2005 wizards to generate strongly-typed datasets, datatables, and table adapters for a client/server application. I use the table adapters on the server to connect to the database and retrieve datatables. I then return those datatables to the client. I would really like...more >>

I'm in a situation where the customer has an Oracle DB, and my developing platform runs a SQL Server DB. Ideally, I'd like to write the code, and then simply change the connection string at deployment time. So my question is: can I use the OleDb classes rather than the native SqlClient classes, to c...more >>

Hi I need to trap the insertion of a new row into a DataTable while it is being filled by a data adaptor. I am trapping the RowChanged event and using the following syntax to try and modify the row: e.Row.ItemArray(index) = newValue The line above executes without errors BUT my change i...more >>

Hi, I'm using a SqlCommand with parametrized sql like "select @field1, @field2, ....". Is possible to see the sql sentence with parameters VALUES, not "@field1, ...." ? It would be great for debugging. Thanks....more >>

Can a database connection be closed without calling the Close() method, like in this example: using (OleDbConnection c = new OleDbConnection("...")) { try { // Open connection c.Open(); } catch (Exception ex) { // Report error } } Or d...more >>

I could have sworn I read MS documentation that said a data reader is the fastest, most lightweight way to read in a table. However, I'm finding that DataAdapter.Fill() is often up to 5x faster. Am I missing something? Also, why isn't there an async DataAdapter.BeginFill() method? Here MS ...more >>

Hi. I have a WinForms App and a SQL Server database. On a form, I have a Data Grid View, showing the contents of table A from my datyabase. One of the columns in the Data Grid View is unbound, and I would like to calculate it´s value from one column in table A and a value taken from elsew...more >>

Hello, I bought your book "Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)", went trough (almost) all de details for registering but never received a response. Just before completing all necesary details; there was no response anymore. When i try to re-register it says GUID ...more >>

Hope someone can help me with this, since I am stumped. I need to apply a filter to a dataset so that I can clone those rows, while keeping the resulting rows in the same natural order as the original dataset. My code right now is something like this: // get data, create clone of table stru...more >>

Hi, I use the System.Data.OleDb.OleDbConnection class to establish a connection to a Oracle 10G database. The dsn connection string I use look like this: dsn=provider="MSDAORA.1";User ID=test;Data Source="172.30.0.25/ JBOS";Password=test; This works fine in Windows XP and Windows server 20...more >>

I have finally been able to import a csv file into a DataTable. The data has invalid dates which won't insert into the SQL table I have. So I have been trying to figure out how to DBNull the invalid dates while still in the DataTable but I don't understand C# (or .NET) enough to know what or...more >>

I am using a ExecuteNonQuery() to insert a record into a SQL Server database. How do I retrieve the identity value of the row just inserted? Bill ...more >>

Can't find a good place for this, but hopefully, this group isn't too far off. I just installed SQL Server Developer Edition, and found a tutorial online to get started. In the tutorial, which is made for Express Edition, they create a database from Visual Studio with the command Add New Item -> SQL...more >>