Using VS 2005, I created data adapters using the IDE. I store a connection object in My.Settings (cool feature) collection. What I'd like to do is seemlessly changed my connection on the fly. Say for instance the production server is down due to network or server hang, the applicaiton should ...more >>

How can we find a Field data types from DataReader/Dataset/Datatable in VB.net ??? For example code in VB6 where rstRecName is a recordset and j is a column index: If rstRecName.Fields(j).type = adLongVarChar Then (do something) end if Thanks for your help Vanny ...more >>

I have a table that I would like to display in a tree view. The table has parent/child relationships (there is a primary key, and another field that points to the parent's primary key). This table is in an SQL Server database (2005). The table is essentially an organization structure (CEO w...more >>

In ADO.NET 2.0, it seems that when the TableAdapter (or its underlying DataAdapter even) doesn't throw a DBConcurrencyException when the InsertCommand SPROC returns Zero Rows Affected. The MSDN Documentation Says: "The DataAdapter examines the number of rows affected by the execution of eac...more >>

Hello, I'm using a lot of threads, each one using it's own instance of my TableAdapter, Connection and DataTables. But all of them will access the same table at the same sql server maybe at the same time (optimistic concurrency, etc.) I found the following in the Documentation: Any publ...more >>

Hey ya, Using .NET 2.0 and SqlCommandBuilder, say I have a customer row, with an address and name fields. I need 2 different clients to be able to change 1 field each and not get ConcurencyExeption on 2nd Update(). Is it possible to do? Thanks...more >>

Hi; The class OracleConnection is part of .NET and so is always available. However, it does not work if the Oracle client software is not installed on a user's system. How can I test for that being installed so I don't offer Oracle as a choice if it can't be used? -- thanks - dave dav...more >>

I am using MS Visual Web Developer 2005 Express Edition, MS Access DB, XP Pro and IIS 5.1 on my local XP Pro. Why does this work: <asp:DropDownList ID="cmbcboFiltLanguageID" Style="z-index: 201; left: 640px; position: absolute; top: 155px" runat="server" Width="377px" Height="20px" BackColo...more >>

Hi there, Can anyone explain the following (very) simple scenario. 1) I make an exact copy of my "DataSet" and delete one record from a given table (in the copy) 2) I invoke "DataSet.GetChanges()" on the above copy and pass the results to "DataSet.Merge()" on the original copy 3) If I no...more >>

What's the alternative to the following? void m_BindingSource_AddingNew(object sender, AddingNewEventArgs e) { MyTypedDataSet.TypedTableRow newRow = this.m_DataTable.NewTypedTableRow(); this.m_DataTable = new MyTypedDataSet.VendorsDataTable(); DataRow[] existingRows = this.m_DataTable.Select(...more >>

Got a puzzler for anyone wanting to take on a challenge. I have some data, which represents something like an insurance policy. The customer may call up and change the level of coverage at any time. These changes may or may not produce a change in premium but may produce a change in legal ob...more >>

Hi, I want to use a DSN connection to connect to MS Access Database. The ODBC DSN has been configured as MIT. I use the following connection string to connect (using VB.NET): Dim cn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; DSN=MIT") This throws up an error: Could not fi...more >>

I would like to create my own data provider in .NET which is able to deliver data to all apps supporting oledb or odbc. Information about this is very rare in the Web. Are there any code samples around or books from which I could learn how to do this? Important, again, is the part which makes th...more >>

Hello ! I read any articles about locking so far, but I am not able to make a solution for my project. (I really want pessimistic locking - no such optimistic/pessimistic discussion please) This is my idea: (I made some experiencies with a new field "locked" in the orders-table - read comm...more >>

Simple problem. If the company is null, replace it with last name and first name: /* Replace null companies with last and first names */ DataView dv = new DataView((DataTable)this.Invoice, "Company = ''", "InvoiceID", DataViewRowState.CurrentRows); foreach (DataRowView drv in dv) { drv....more >>

I am using MS Visual Web Developer 2005 Express Edition, MS Access DB, XP Pro and IIS 5.1 on my local XP Pro. This is a Newbie question with a very simple answer (I think). When I run the page it loads up just fine (with all of DB fields in the dropdown boxes, etc.). The problem is when I g...more >>

I am using VS 2005 and a MS Access 2003 DB. In VS I use the server explorer to drag and drop tables and existing queries into the dataset designer window. I am having several problems. 1. In the Server Explorer tables are under the Tables folder but queries are under the Views folder or i...more >>

Hi, I get errors when I try the following expression in my strongly typed dataset: "Sum(Parent.Child(Relation1).Value)" The error I get is: "Syntax error in aggregate argument: Expecting a single column argument with possible 'Child' qualifier." What I want to do is to navigate fr...more >>

The GetSchema documentation hurts, specifically: "Understanding the Provider-Specific Schema Collections" at http://msdn2.microsoft.com/en-us/library/ms254969(VS.80).aspx I'm trying to create a DataSet that matches an SQL Server database, and I've gotten close. I'm calling SqlConnection's ...more >>

Hello, I have a DataGridView, bound to a typed DataTable (without any TableAdapter etc.). The values of that DataTable are changed in a second thread using the following code: DataSetOrderManager.DbOrderManagerWlanRow row = dtWlan.FindByHardwareID(HardwareID); if (row != null) row.Las...more >>