Archived Months
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
December 2007
January 2008
February 2008
March 2008
April 2008
all groups > dotnet ado.net > april 2004 > threads for monday april 5

Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30

Copying a Row in a datagrid
Posted by Dean Landry at 4/5/2004 10:26:55 PM
Hello, I am trying to duplicate a row in my datagrid. Below is my code. After I duplicate the row I manually change one of the primary key fields so that there isn't a problem with duplicate rows. But from time to time, after using the function below, I get the "The Changes you requested t...more >>


When mergint dataset, edited rows getting added once again.
Posted by Bibin at 4/5/2004 6:18:02 PM
Dear All, I am developing an application in .Net. I put one Business Logic Layer and one Database Layer. In the user interface I will be picking all the records, will be editing. then I will pass the edited dataset to the business Layer. In the Business Layer, It will be taking the change...more >>

Stored Proc using MS Application Blocs
Posted by Schoo at 4/5/2004 5:04:05 PM
I have an ASP app that works but I am trying to make a change that is not working. The app uses MS Application Data Blocks to call a stored procedure. The way I originally designed it, the user opens the first screen, selects an item from a list and the program calls an object I created which...more >>

Nothing showing in results
Posted by dazza at 4/5/2004 3:16:03 PM
I've been having probs for weeks with VS.NET / ASP.NET and just established that even a simple form doesn't work. Please help; its put a hold on my project for weeks Just ran a simple exercise from a sample chapter in this book ran this real simple exercise: http://www.programmersheaven.com/other...more >>

hierarchical data headache
Posted by sklett at 4/5/2004 2:35:00 PM
** repost with more info ** I am not very good at SQL queries. I just can't get it. With that said, I need some help really bad figuring out a way to get some data to present hierarchically. Here is the sitch' I want to display product FAQs like this: PRODUCT FAQ CATEGORY F...more >>

GetOleDbSchemaTable question
Posted by burak.gunay NO[at]SPAM xpandcorp.com at 4/5/2004 2:27:53 PM
Hello, I am trying to retrieve the list of tables in local oracle database, "SKILLS". When I use the following set of commands strsql = "select TABLE_NAME from user_tables" objconnection = New OleDbConnection(strConnection) da = New OleDbDataAdapter(strsql, objconnection) da.Fill(ds, ...more >>

Invalid attempt to Read when reader is closed
Posted by joyce_stansell NO[at]SPAM norampac.com at 4/5/2004 1:59:11 PM
Help. I am new to VB.NET 2003. I have written an application for SQL CE (also new at) and I am very frustrated. This is the code: strSQL = "INSERT INTO ROLL(RNO, SPCD, UPDATES, CONTIME, STCD, PSCD, LOCD) " & _ "VALUES('" & strPrevRoll & "', '" & strSpeed & "', 0, '" & datCurre...more >>

Datagrid columns using AutoGenerate via the autoGenColumnsArray private member array collection (reflection)
Posted by googlegroups-gaijin42 NO[at]SPAM sneakemail.com at 4/5/2004 1:45:28 PM
I have seen several people looking for a way to access the Columns collection when using the AutoGenerate = true option. Some people have gotten so far as to find the private autoGenColumnsArray that has the information, but we as developers have no way to access this information. I have com...more >>



Update Question
Posted by ion at 4/5/2004 1:25:38 PM
In my application I use typed datasets as my data container classes (data persistence). My db structure has many table relations (mostly one to one). I have main table that maps to 4 different tables using an ID which is auto incremental. So, when I persist this info while the user inputs it, ...more >>

ODBCDataReader dBase IV
Posted by Kevin ghantous at 4/5/2004 11:56:03 AM
Hey I am attempting to read data from a dBase IV database. After hours of struggling, I finally got my connection string working -- so I felt I was pretty well off. I was wrong The problem I'm having is when I perform an ExecuteReader, I get back a ODBCDataReader, which is fine. I can call th...more >>

update problem in dataset....
Posted by Raphaël Désalbres at 4/5/2004 11:52:15 AM
Hello, I've the following problem: A simple table (Users) with 2 fields, UserID (Primary key) and UserName The code: dim cnn as new oledbconnection cnn.connectionstring="Provider=Microsoft.JET.OLEDB.4.0;Data Source=" & server.mappath("bd1.mdb") cnn.open dim da as new oledbdataadapter...more >>

Typed Dataset: Stetting DataColumn-values
Posted by Michael Maes at 4/5/2004 11:14:51 AM
Hi, How do you set the settings (like MaxLength, ReadOnly, DefaultValue, = ....) in a DataColumn of a Typed Dataset. I know you can do this in Run-Time (eg: = dataset.datatable.datacolumn.MaxLength =3D 4) but I want to do this in = the XSD Schema-Designer (or XML-file) Thanks for any hint,...more >>

getting back a data row with a PK
Posted by Brian Henry at 4/5/2004 11:07:47 AM
Hi, I have a dataset with a table, the table has its primary key set. How can i get back a specific data row from that table by using the primary key only? thanks ...more >>

Reading a lot of rows, how to get better performance without GetRows() ?
Posted by Thomas Jensen at 4/5/2004 9:35:41 AM
Hi, I'm replacing a VB application with a .NET application written in C#. Previously I have been using the GetRows() function of ADO recordsets quite extensively, because in the case of the old application it would lower data retrival time several times. I think the problem is that my dat...more >>

FileStream GURU Help - Filestream and Icon files .NET SQL2000
Posted by rcl58 NO[at]SPAM iglou.com at 4/5/2004 9:27:55 AM
The code below gives me an "Out of Memory" exeption when the PictureBox1 is assigned. If I use the same code but relpace the CIRC.ICO with a Test.JPG file it works! Is there something special about .ico files? Suggestions? Thank Bob Dim fs As New FileStream("c:\CIRC.ICO", FileMode.Open, ...more >>

Data Adapter Wizard
Posted by Parveen at 4/5/2004 9:11:04 AM
I want the data adapter wizard to automatically generate update, insert, and delete statements from a given select statement if the select statement is a multiple table query. I know this works with single table select statements. Does anyone know how to make this possible with multiple table s...more >>

Error with OracleParameterCollection after 1.0 to 1.1 upgrade
Posted by hilary321 NO[at]SPAM yahoo.com at 4/5/2004 7:20:07 AM
Probably been asked before but I cannot find a resolution: I receive the following error when calling a stored proc in Oracle but this works with v1.0 of the framework: The OracleParameter with ParameterName 'p_Subscriber_ID' is already contained by another OracleParameterCollection. Any ...more >>

dataviewmanager problem
Posted by jpribele NO[at]SPAM bglgroup.com at 4/5/2004 5:33:21 AM
sorry for the repost i just want this to be its one thread. Please tell me what I am doing wrong. I have the following DataTables Establishments (Id, <other stuff>.... ) Bookings ( estabId, <blah>.... ) I created a DataSet with a relationship between id and estabid. This all works great...more >>


DevelopmentNow Blog