OK i removed all of my datasets to start fromo scratch again with another method. Is there a way i can create all my datasets in the MDI Parent form and reference them from child forms ******************* for instance i just created dsName1 in the MDi Parent and the dsName.xsd was created in...more >>

Hi, This is code from MSDN help (OracleDataAdapter.UpdateCommand Property) ' Create the UpdateCommand. cmd = New OracleCommand("UPDATE Dept SET DeptNo = pDeptNo, DName = pDName " & _ "WHERE DeptNo = poldDeptNo", conn) cmd.Parameters.Add("pDeptNo", OracleType.Nu...more >>

I have a MDI Program and several child windows. On one child window a dataset is loaded with trailer_Num & Trailer_ID only On another the dataset is loaded with trailer_Num, Trailer_Location and several other fields. My Datasets have been declared in each child Window, but when i change win...more >>

Hi, I have a DataTable with some rows and bind to a DataGrid. The first column in the DataTable is an AutoIncrement value. I am clearing the rows in the DataTable by calling DataTable.Clear(). After this I want new rows in the DataGrid to start with AutoIncrement value of '1' instead of con...more >>

Hi I read through quite a few news postings and articles related to the Concurrency issues in ado.net. .. But didn't get the concept and hence has not solved my problem. I have a asp.net app. where user submits a form to the database. The asp.net appl. calls a SQL2K stored procedure to per...more >>

Îáû÷íàÿ ÏîäïèñüDo i have a possibility to work with ASP.NET Web-Service in the client, written in Java? ...more >>

Hi Guys, I'm trying to use a checkbox control in a datagrid. The objective is to display readonly Customers from a database, then allow a user to select customers with the checkbox. Then, iterate through the dataset extracting the primary key fields and submitting them to a stored pro...more >>

Hi NG, can I assign another stored procedure as select statement to a data adapter during runtime ? thanxx for answer P@rick ...more >>

When running the sp from Query Analyzer, or even firing it from the command window in VS.NET, the sp returns the correct value (an incremented one). However, in code it doesn't update the variable i'm assigning the result too. I'm guessing it's some sort of caching??? Here is the sp: ALTE...more >>

I'm working with a database that has 100+ tables and the average table has at least 40 columns. using the OleDbParameter class, some tables use Timestamps, and other use Dates, but when retrieved from the database, using a DataRow, they all show up as System.DateTime objects. Now when I update t...more >>

Hi When I'am trying to configure DataAdapter it gives me error like in subject. After I reduce number of fields in select formula all is ok. How to avoid this problem? It concerns Access database. Thanks Konrad ...more >>

I have written a program that uses ODBC connections. Can anyone tell me how to have it create the System DSN for an access database on load? or in the deployment package?...more >>

DbType myDataType = (DbType) SqlDbType.Image; ...more >>

Hi How to add primary key column to DataTable which have no primary key? Using if possible ADO.NET. It concerns Access database. Thanks Konrad ...more >>

I have a datareader object where I am trying to convert the fields coming from it into my structure. The line in question is as follows: col.Length = (reader.IsDBNull(2) ? (short)0 : reader.GetInt16(2)); col.Length is defined as a 'short' (BTW, this is in C# code, using the intrinsic shor...more >>

Please forgive the restatement of my post from a few days ago, but I hope this question is more clear. I'm working with a C# Windows Forms app. What is the best practice for handling the changes made by a user that occur after an asynchronous update has been initiated, but before the upd...more >>

When setting up an SqlCommand object, is it required and/or recommended to use the size parameter when the data type of the parameter is text (SqlDbType.Text)? I'm converting an old program and I'm a ways away from testing it, so I figured I'd ask first. In ADO specifying a size (for adLongVarCh...more >>

I am trying to add some new records to a table and I have the new records in memory in a typed dataset. How can I update the database with these new records without loading the entire table into a dataset (it is quite large)? Jeremy Summers ...more >>

I want to ask the DB how large a varchar column is so I can ensure that strings being inserted there are not too long. thanks in advance, John...more >>

Hello again: I think in the next version of the .NET Framework, OleDbCommandBuilder should use square brackets when generating commands for column names with spaces. UPDATE [My Column] column2 [Column 3] ... ... Otherwise it throws an OleDbException "Incorrect SQL statement sintax" when ...more >>

Hello: I first put the code and then I'll comment it: .... somewhere in Form_Load ... Binding binding = new Binding("Value", myTableDataView, "StartupDate"); binding.Format = new ConvertEventHandler(StartupDateBinding_Format); StartupDateDateTimePicker.DataBindings.Add(binding); .... ...more >>

I am trying to get the value from an Autonumber field in an Access97 database when I insert a record into it. My code is always returning 0 as the value which is wrong can anyone see what the problem is? Thanks in advance. Private cmdGetIdentity As OleDbCommand Private Sub btnNew_Cl...more >>

Here's my situation... First off, I'm a complete Newbee when it comes to 'data bases'. And I'm a week end programmer (: My appologies if I get a bit too verbose here I've VB4 to VB6 experience... and have started using VB.net just this year. Most of my apps have always used TXT type files fo...more >>

'Insert, delete and update buttons 'don't work, the full source code is: Public Class WebForm1 Inherits System.Web.UI.Page Protected WithEvents Button1 As System.Web.UI.WebControls.Button Protected WithEvents Button2 As System.Web.UI.WebControls.Button Protected WithEvents...more >>