ASP.NET

ASP.NET RSS

insert query in c#

Please support our ASP.NET advertiser: Intel Parallel Studio Home

Thread Solved

•

Join Date: Dec 2008

Posts: 30

Reputation: sonakrish is an unknown quantity at this point

Solved Threads: 1

sonakrish

Offline

Light Poster

insert query in c#

Jan 21st, 2009

 Help with Code Tags 
 sql Syntax (Toggle Plain Text) 
INSERT INTO desg VALUES(" & Val(txtsno.Text) & ",'" & Trim(txtdesg.Text) & "'," & Val(txtbasic.Text) & ");
insert into desg values(" & Val(txtsno.Text) & ",'" & Trim(txtdesg.Text) & "'," & Val(txtbasic.Text) & ");

this how i used for inserting data to my access table in vb code.
how to do in c#?

Last edited by peter_budo; Jan 21st, 2009 at 7:55 am. Reason: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks) and [icode] (inline code) tags.

•

Join Date: Jan 2009

Posts: 2

Reputation: snehachoudhary is an unknown quantity at this point

Solved Threads: 1

snehachoudhary snehachoudhary is offline

Offline

Newbie Poster

Re: insert query in c#

Jan 21st, 2009

•

Originally Posted by sonakrish

"insert into desg values(" & Val(txtsno.Text) & ",'" & Trim(txtdesg.Text) & "'," & Val(txtbasic.Text) & ");" this how i used for inserting data to my access table in vb code.
how to do in c#?

I am unable to understand the motive the query.Give wat you want to do.

•

Join Date: Dec 2008

Posts: 104

Reputation: Aneesh_Argent is an unknown quantity at this point

Solved Threads: 18

Aneesh_Argent Aneesh_Argent is offline

Offline

Junior Poster

Re: insert query in c#

Jan 21st, 2009

 Help with Code Tags 
 sql Syntax (Toggle Plain Text) 
"INSERT INTO desg VALUES(" + txtsno.TEXT + ", " + txtdesg.TEXT +", " + txtbasic.TEXT + ");";
"INSERT INTO desg VALUES(" + txtsno.Text + ", " + txtdesg.Text +", " + txtbasic.Text + ");";

You dont need to worry about Trim and Val functions here. Trim will happen automatically and Val is irrelevant here

•

Join Date: Sep 2007

Posts: 1,080

Reputation: SheSaidImaPregy is an unknown quantity at this point

Solved Threads: 68

SheSaidImaPregy SheSaidImaPregy is offline

Offline

Veteran Poster

Re: insert query in c#

Jan 22nd, 2009

You should also stear away from inserting code just like that. Look into adding parameters:

 Help with Code Tags 
 ASP.NET Syntax (Toggle Plain Text) 
SqlCommand comm = new SqlCommand("INSERT INTO desg VALUES (@txtsno, @txtdesg, @txtbasic)", connection);
comm.Parameters.AddWithValue("@txtsno", txtsno.Text.Trim());
comm.Parameters.AddWithValue("@txtsno", txtdesg.Text.Trim());
comm.Parameters.AddWithValue("@txtsno", txtbasic.Text.Trim());
SqlCommand comm = new SqlCommand("INSERT INTO desg VALUES (@txtsno, @txtdesg, @txtbasic)", connection);
comm.Parameters.AddWithValue("@txtsno", txtsno.Text.Trim());
comm.Parameters.AddWithValue("@txtsno", txtdesg.Text.Trim());
comm.Parameters.AddWithValue("@txtsno", txtbasic.Text.Trim());