Ad:

ASP.NET Discussion Thread
Marked Solved
Views: 19770

Jan 21st, 2009

insert query in c#

Expand Post »

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.

Similar Threads

Update and insert query in one in MySQL
How to insert data into database? in JSP
execute one insert query and two update query, in one single button click. in VB.NET
help with my insert query in PHP
need help with insert.php in PHP

sonakrish

Reputation Points: 10

Solved Threads: 1

Light Poster

Offline

34 posts
since Dec 2008

Permalink

Jan 21st, 2009

Re: insert query in c#

Click to Expand / Collapse Quote 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.

snehachoudhary

Reputation Points: 10

Solved Threads: 1

Newbie Poster

Offline

2 posts
since Jan 2009

Permalink

Jan 21st, 2009

Re: insert query in c#

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

Aneesh_Argent

Reputation Points: 16

Solved Threads: 18

Junior Poster

Offline

104 posts
since Dec 2008

Permalink

Jan 22nd, 2009

Re: insert query in c#

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

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());

This prevents SQL Injection.

SheSaidImaPregy

Reputation Points: 43

Solved Threads: 68

Veteran Poster

Offline

1,080 posts
since Sep 2007

Permalink

Dec 10th, 2009

Re: insert query in c#

sonakrish how do i insert Radio box value into the access database. for example, S=Small, M=Medium, or L=Large.

indianj

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

2 posts
since Dec 2005

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in ASP.NET Forum Timeline: SilverLight

Next Thread in ASP.NET Forum Timeline: How to create blogs in ASP.net C# home page

DaniWeb Message

Cancel Changes

User Name
Password