inserting data into Sql Database

CodeMonkeys · August 19th, 2004, 05:29 AM

Hi
I have a windows app with a datagrid, sqlDataAdapter, sqlConnection and a dataSet.
I want to input data into text boxes on a Windows App, then by clicking a button insert the data into a data grid and then into my sqldatabase.

Any help please

CodeMonkeys

melvik · August 22nd, 2004, 11:08 PM

Ok I soppose ur datagrid has the same value as ur textBox!
First u fill need 4 commands for Select/Update/Insert/Delete.
& As Microsoft recomended make 4 SPs in ur Datanbase (in MS-SQL)
Then fill ur dataset & [u]bind</u> ur controls & then when u updated ur controls cuz they r binded the Dataset will update so u will only need to call ur DataAdapter.Update() method!
& about inserts let me tell u by a simple sample.

Code:

DataRow anyRow = ExistingTable.NewRow();

anyRow[0] = "Jay";
anyRow[1] = "Stevens";

ExistingTable.Rows.Add(anyRow);

& Then call

Code:

DataAdapter.Update();

HTH, & plz keep in touch in every faced problem.

Always:),
Hovik Melkomian.

mehdi62b · August 23rd, 2004, 06:08 AM

although,you can ignore Microsoft recommendations! and instead of making four command just use a CommanBuilder object ,then dont worry about your queries CommanBuilder object sends them for you when you update your adapter.
(this method works only for one table).

--------------------------------------------
Mehdi.:)

dcathers · August 25th, 2004, 03:40 PM

Keep in mind, the CommandBuilder is not 100% reliable for all platforms. If CommandBuilder is just not working, you may have to code your update statement manually.

Hal Levy · August 25th, 2004, 04:35 PM

Um, do you have that Documented somewhere?

Hal Levy
Web Developer, PDI Inc.

NOT a Wiley/Wrox Employee

dcathers · August 25th, 2004, 05:23 PM

No, but when I did a search on the internet I found that lots of people were advising against using it for its unreliability. Plus I found with my own experience even though I did everything as recommended and explicity defined a primary key, it still returned a primary key not defined error.

So even though I am not completely sure I missed something, my several hours wasted trying to fix it combined with all the other people on the net saying how unreliable it is lead me to conclude it is not 100% reliable.

coderforrent.com · August 31st, 2004, 04:21 PM

I have been using the CommandBuilder for a while now and I have never had a problem . I use it every day. I have found it to be the quickest and easiest way.

www.CoderForRent.com
Get A Computer Job!