Hi, I'm having a problem with data binding to a windows form. I have a form that is bound to a datasource that contains a main table and several subtables that are related to the main table via a key field. I connect to the database and read in each table to a dataset using separate OleDbDataA...more >>

Trying to learn ASP.Net and I have a few simple (or at least I hope they are simple). If you are creating "codebehind" to hold all of your code, would you also place any client scripts here as well or do they still have to go on the .aspx form? If I write my script in VB or C#, will it a...more >>

When I use the Form wizard to add a DataSet, DataTable and connect a DataGrid to the DataTable, the expression is never evaluated in the calculated column. Is this a known bug in VS.NET 2003? Is there aworkaround more convenient than the one I give below? Thanks for any answers... Here is ...more >>

Yes, I know how to use it, but darn...I could do what I want to do in ADODB (non-dotnet) with just a few statements, ADO.NET (which is supposed to be better) requires more than 1000 statements to do the same task! There is no easier and quicker way in ADO.NET. I've got 33 tables, all these ta...more >>

Hello, I have an interesting design problem, I would like to have your opinion on. I have table DRAWINGS, which has a field DrawingName which contains a list of drawings with thier full path. Eg- c:\winnt\mydrawing\room.dwg I have a table ATTRIBUTES which has a field DrawingName which co...more >>

I was trying to update a record from a transaction and simultaneously trying to read the record. Both the transactions were set to the default ReadComitted Isolation level. Now I found that the Read blocked, even after the other transaction had finished its update operation(of course, not commit...more >>

Hi, All: I have this error. It seems execution time is too long. Actually the = execution time is about 30 seconds(I tested in Query analyzer). How do I = solve this problem? System.Web.Services.Protocols.SoapException: = System.Web.Services.Protocols.SoapException: Server was unable to = ...more >>

I know how to use various .find methods to identify a row index, but I want to do the same for 'bookmark' type purposes in a simple datatable loop. For example, Dim dainvdtmcrd As New SqlDataAdapter("select imcacct from invdtmcr order by imcacct", oconn) Dim dsinvdtmcrd As New DataSet("invdt...more >>

We have built a web app which we subjected to a stress test after which we checked sql server Management - Current Activity - Process Info and found quite a few open connection that were taggedd "sleeping" and "awaiting command". Does this mean these are "orphaned connections"? We h...more >>

I'm using the following code to update my DataSet and then update the datasource, a SQL Server 2000 database. The code runs without throwing the error. However, when I look at my SQL DB Table all of the decimals that I attempted to pass into it have been stored as a 0. The strings are...more >>

VB.Net i catch an SQLException having message: "Line 1: Incorrect syntax near 'ContractNum'." while trying to update a datasource via a data adapter. is there any way to retrieve the SQL command string that caused the error directly from the Exception object? I can, of course, get the strin...more >>

Can anyone suggest the best known way to connect a windows app (vc#) to a database (msaccess) stored on the web? I'd like to make inserts from my windows app.. Thanks in advance, Tommie C-...more >>

General Question: Can you create a dataset which you know will return no rows and then use the typed dataset to then post inserts back to the database? Tommie C-...more >>

The Dispose() method of SqlConnection will automatically close the connection if it is open, but the Dispose() method of SqlDataReader doesn't appear to close the reader, is this by design? using(SqlConnection _connection = new SqlConnection()) { } // SqlConnection closed by SqlConnection...more >>

we have been develooping a database application in .net c#. I want to learn what is the benefits of using web services when accessing data instead of accessing data without web services? ...more >>

I know about "sqlwish". Is there an ADO.NET-Wish mailbox at Microsoft? I've been building a complex data calculation engine that makes liberal use of ADO.NET typed DataSets, among other things. In the development process, I inevitably screw things up now and again and get the infamous System...more >>

Hi friends! Is it possible update or delete a several records in a DataTable/DatSet object using a simple SQL Update/Delete statement? I try to see in the documentation but that I understand is that only record by record making a loop it is possible, not using a SQL Statement. If I do in ...more >>

Hi there! We are writing an application with a form wich has a master table and 7 detail tables on it. Each table has its own DataAdapter, but it dures 0,3 seconds to load one of them, in sum it dures 2,1 seconds. So, each time we navigate to the next datarow it dures 2,1 seconds!! What a...more >>

I am still looking for a solution of passing an ADODB Recordset back from a remote script call - any help or direction would be appreciated. Karen...more >>

Having struggled in vain with the idea of making custom business objects, I'm now wondering how safe it is to just modify a Typed Dataset. It would be simple enough to add validation logic to the property code. My fear is that once I've modified the dataset code, Visual Studio is going to go ...more >>

I have a form with some textboxes, combos and checkboxes. I use a dataset witch I bind to a Currencymanager. Everyting is perfect until a run CurrencyManager.AddNew. Now I want all the textboxes to clear so I can enter new values. When I have one or more checkboxes bounded this will stop w...more >>

MS Partner this is the latest version of security update, the "October 2003, Cumulative Patch" update which eliminates all known security vulnerabilities affecting MS Internet Explorer, MS Outlook and MS Outlook Express. Install now to continue keeping your computer secure from these vulnera...more >>

Dear friends, a summary of my problem: Update method adds new row in the database (as expected) but then raises an exception as if it failed to update. I have a form with binded controls. Most of them bind to a main table and some of them bind to a secondary table. These tables are rel...more >>

I have a dataset with one table with two fields (LastName and Firstname). With SQL I "create" one more field: SELECT FirstName & ' ' & LastName AS Name FROM Names; Now i have 3 fields in my datatable. The problem is when I update the dataset, the field Name doesn't update. How I can updat...more >>

In ADO I had no trouble doing the following: My Access tables would usually have autonumbering ID fields as the key. Other values were required. Some had default values. Using the dataforms, or grids or code, when I added a row I wouldn't put in a value for those fields with default va...more >>

Nobody reacted on the question below yet, maybe it is a stupid question, but can somebody then please explain why it is stupid :-) When queriing on a date on a DataTable a thought I should use the Date.ToShortDateString() format, for instance like this: DataRow[] resultRows = dataTable.Sel...more >>