i have written a stored procedure in Oracle with client Oracle 8. This procedure is called by an ASP.NET Application with Code written in C# PROCEDURE Spvalidatemobilenumbernew( pinumOldMobileNumber IN SERIALNUMBERTRACK.N_SERIALNUMBER% TYPE, pinumSimNumber IN SIMMOBILE.N_SIMNUMBER%TYPE, p...more >>

am having problem updating data with dataadapter....in some of my tables. I realize that, Dataadapter doesn't SOMETIME fire event rowupdating even if there are new rows. Because of that,rows are not updating in Databases. I use olecommandbuilder to generate Insert command. Update and ...more >>

I've used the OldDbCommand to retrieve some data (SELECT query) -- I have two questions. 1. How do I find out how many records where retrieved WITHOUT looping through the results and incrementing a counter? Is there a direct way of some sort? 2. How do I initialize an array and add all my P...more >>

I'm trying to get data out of an excel file, but for first column below the Type is System.DBNull. The other 2 columns the Type is System.String. But then after a few more rows, a second column's type becomes System.DBNull so whenever the type is System.DBNull, I can't get the cell value...more >>

OK, I'm nulled out. I am converting a dbase based enterprise wide system that has almost 100 tables to convert into a vb .net system using ms sql server 2000 (I am posting this both to ado .net newsgroups and sql server newsgroups). I am working with a prototype where many of the columns in m...more >>

Having a little trouble getting at my data after the webform I'm using is submitted. Perhaps this is better posted to web forms, but its my ADO implementation that seems to be the problem. I'm using a DataSet control on a form that I bind the form's controls to. But when I check that DataSet ...more >>

Hi,I am trying to a several rows like this: 1. Get new datarow from typed DataTable object (datatable) 2. Set datarow's values (except the primary key - it's marked as identity and is generated by sql server) 3. Add datarow to my datatable object after adding several rows I call Update on ...more >>

I have a text field with a value. What is the easiest way to update the database with this value? I think a dataset would be overkill. Can't I just run the UPDATE SQL command directly? Can you provide a sample? Thanks. ...more >>

The current version of my company's app uses RDS objects for all of our data access/updates. Our new version of the app will be built in .NET. In playing around with ADO.NET, it seems to me, it seems to me that ADO.NET is a TON slower than RDS was. Can anybody help me set up ADO.NET to ...more >>

I created a Datagrid and made a bind with a Dataset Table. I don't want to see all the colums of the table, so a made a TableStyle and two ColumnStyles (at design time). When I run my application all the columns of the table are shown instead of the two I made of my own. I can, of course, cha...more >>

Hi all I am changing from VB and ADO 2.7 to C# and ADO.NET . The Recordset Object from ADO 2.7 has a Method "next" . Is there a similar Method when i am using a Dataset perhaps in the Datatables or Datarows ? Is it possible to navigate through a Dataset like Recordset from ADO 2.7 ? Bes...more >>

I have a arraylist of workorders that I can bind to the datasource of a datagrid. However, each workorder has a building object that has properties as well. How can I access these subproperties of the building object in the datagrid? I can access these single level fields easily Wo...more >>

background: I have a table in the database, 1 column in the table is a primarykey. 2 columns in the table do not allow nulls (one of those columns being the column that is a primarykey) problem: DataColumn [] dc = myDataSet.Tables["mytable"].PrimaryKey; MessageBox.Show(dc.Length.ToString...more >>

Hi, I have a dataset that contain one row, I like to replace this unique row by another one that contain the same information (with a new version number), this is my code Dim myRow As DataRow Dim newVersion As String = getNewVersionNumber() ' a function that return a new version nymber ...more >>

I need to pass along parms in an SQLConnection. EG con = (New SqlConnection("Data Source=mySQLserver;user id=UserName; password=UserPassword;Initial Catalog=northwind")) The function is passed the values as parms and needs to pass them along to SQLServer. ie: <WebMethod()> Publi...more >>

Folks, I've defined my dataset by means of an XSD, and it works okay - I was wondering if there's a way to specify default values for columns (e.g. true/false for booleans) in the XSD itself? Can't seem to find anything..... but there's *got* to be a way, no? Marc =======================...more >>

I have a datagrid bound to a table called tableEvents. I havesuccessfully managed to manually code the insert, delete, select statewments, but the update is giving me problems. I installed a handler which fires on row changed. Th rowheader gets a little exclaimation mark in a red circle after u...more >>

I have generated a strongly typed DataSet class with one DataTable. Supose DataSet class name is DSCustomers and embedded DataTable class generated by VS is CustomersDataTable. I am not sure if it's safe to do and use this: DSCustomers.CustomersDataTable table = new DSCustomers.CustomersDataTabl...more >>

How do you call an existing procedure? My database has a procedure called "StudentSchedule" with one parameter, @StudentID. I'm trying to fill the results in a datagrid with a StoredProcedure command. The grid is not even showing on the page. SqlCommand cmdSchedule = new SqlCommand(, this....more >>

I have a very simple example that I am trying to get the update and delete (through DataAdapter) working. I have the insert working just fine, but the update/delete do not work. This is a win app if that matters. I get a concurrency update (or delete) error saying that no rows are updated (or ...more >>

I usually put my declarations for db connections, datasets, datareaders, etc... above the Try portion. Inside the Try is where I open my connection, executereader, etc... In the Catch portion I usually "clean it up", with closing the datareaders, connections, etc... Is this the best way to do ...more >>