Hi all can any body tell how to create runtime(on fly ) database in asp.net thanks in advance. kapil ...more >>

Thanks, Ben...more >>

Hi How can i get the record count for the OleDbDataReader (or the associated oledbcommand)? Thanks Regards ...more >>

I would like to to retrieve the information about reports from Access database using C# (particularly - SQL query). Can some one give me needed steps? Is it possible to do this without using the automation? Thanks in advance, Dmitri Demyanik AITOC, Inc - ecommerce solution provider and web...more >>

Thanks to David Sceppa for answer to my earlier question. I'd like to know if there's a real-world WinForms application (like "duwamish") showing best practices with BindingManager and bound controls. I'd like to compare what I have against an "expert" approach to see where mine is lacking...more >>

The new release of Generic ADO.NET is ready (2.0). You can find this project on sourceForge at: http://sourceforge.net/projects/genadonet/ This version has gone as far as creating a new data provider with the prefix "Gen". It contains classes "GenConnection", "GenDataAdapter" and so forth as...more >>

OleDbConnection class has GetOleDbSchemaTable method which gives schema information of database. There is no such method (GetSqlDbSchemaTable) for SqlConnection class. How shall one go for getting schema information for SqlServer database? (basically I want schema information of each field...more >>

I've managed to work with disonnected sets enough to retrieve and navigate datasets. But, How you use use the command builder to dynamically insert, update and delete rows? I'd like to use getinsertcommand, getupdatecommand, getdeletecommand methods, but I can't figure out how to call a method t...more >>

Hi, I have a strang problem with a form that have 5 tabpages and on each page there is a datagrid. The problem: I can't get the getchanges work (although on other forms it works fine) ! It seems that when I change from tabpage, the datagrid does an accepthanges so there are no visible change...more >>

I am trying to programatically add a table to an existing Access database. I can create the table exactly as I need to except for one problem. One of the fields in the new table has to be an autonumber and I cannot seem to do this. The usual create table command would be something like: ...more >>

When you call Fill method passing a DataSet object and table name, is that table name associated with the SQL Server table name or just the moniker that will be attached to the generated table inside thee DataSet's TableCollection? What if you call Fill() without passing a table name, does SqlDa...more >>

Hi, I'm using the Calendar Control in an C# SWF application. I have a field in an Access Table which is of the Date/Time type. In access the dates are stored with a time index aswell, but I don't need to care about those. So lets say I have this in the table 11-02-2003 11:36:21 02-05-...more >>

i want to perform multiple inserts by value into an access table in 1 operation. i know how to do this with multiple, separate queries... i don't want to do that because it is making my save operation take 5 minutes for a 3mb database, which is ridiculous. here is what i've tried and none of t...more >>

Hi I have a DataTable object which contains say 1000 records. I want to clone this DataTable but the clone must only contain the rows i want e.g. rows 0-240 (i.e. a subset) thanks hs ...more >>

Hi, Are there other ways to query an XML document using ADO.NET besides using XPath as outlined in http://support.microsoft.com/default.aspx?scid=kb;en- us;308333? Thanks, Dave...more >>

Hi, When I use the data form wizard to generate a form for a table in my SQL database, then it creates the DataAdapter and the Connection automatically. So far so good, but it generates the OLEDB connection and not the SQL connection object (same with the dataadapter). Is it possible to tel...more >>

When I use SqlCommand directly instead of using DataAdapter/DataSet model, f.e. I open the connection, execute the query and then close it virtually right away(the exception handling should it get there is just a few instructions). Isn't this really what DataAdapter does underneath, I'm just not...more >>

I think that in the case of calling SPROC, both methods will execute the SPROC, but ExecuteReader() will return the resultset from the last SELECT query contained in the SPROC, should it contain one. Is this correct? ...more >>