How to insert data from textboxes to sql database in c#? Also how to give values to foriegn key column?

Question

1.33/5 (3 votes)

See more:

How to insert data from textboxes to sql table in c#?
i tried this but i know it is not completely right

SqlCommand add_d = new SqlCommand("Insert into Dealer" + "values('" + D_B1.Text + "'," + D_B2.Text + "'," + D_B3.Text + "'," + D_B4.Text + "'," + D_B5.Text + "'," + D_B6.Text + ")", connection_a);
add_d.ExecuteNonQuery();

Dealer table also has a foreign key, how to deal with it?

Posted 14-Jun-11 22:18pm

Sweety Khan

Add a Solution

4 solutions

Solution 2

What error do you get?

First visible mistake is "Insert into Dealer" + "values('"
There would be now space between Dealer and values, which will definitely give an error. Change it to "Insert into Dealer" + " values('"

Secondly, though we don't know the data structure of table, if you have any numeric column in table, remove the enclosing ' marks from your command.

I hope this will help you. Try to learn more. You can use google.

Posted 14-Jun-11 22:24pm

Prerak Patel

Solution 1

Best way to do this is to use SPs. Also when you are inserting it is better to specify the columns you want to use.

Posted 14-Jun-11 22:23pm

RakeshMeena

Comments

Sweety Khan 15-Jun-11 5:21am

oki. if im using all the columns then can i write like this? n sorry i dont understand wht do u mean by SPs

Uday P.Singh 15-Jun-11 5:31am

with SPs he mean Stored Procedures

Solution 4

you can use this link to use SPs:

Insert and retrieve data through stored procedure[^]

hope this helps :)

Posted 15-Jun-11 6:32am

Uday P.Singh

Comments

Sweety Khan 15-Jun-11 12:51pm

hmm quite similar to what u told as parametrized query

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Uday P.Singh · Accepted Answer · 2011-06-14T23:41:00

Solution 3

Don't do this way use parametrized query or use SPs to avoid sql-injection attacks

you can do this way:

MIDL

string db1=textbox1.text;
string str = "Data Source=ABC-Pc\\SQLEXPRESS;Initial Catalog=mydb;Integrated Security=True";
 SqlConnection conn = new SqlConnection(str);
conn.open();

string insertquery = "insert into marksheets(dbfield1) values(@dbfield1)
SqlCommand cmd = new SqlCommand(insertquery, conn);
cmd.Parameters.AddWithValue("@dbfield1", db1);

cmd.ExecuteNonQuery();

like this you can add as many fields as you want.

hope this helps :)
for further queries comment here!!

Posted 14-Jun-11 23:41pm

Uday P.Singh

Comments

Sweety Khan 15-Jun-11 9:47am

ok by this its done thanx. i left that way but its a very short code. i wanna know how can i do this by SPs plz tell me

Sweety Khan 15-Jun-11 9:48am

one more thing left tht how to deal with foriegn column

Uday P.Singh 15-Jun-11 10:21am

which is your primary key table and field name for this foreign key table?

Sweety Khan 15-Jun-11 12:20pm

Administrator is the primary key table and Admin_ID is its primary key. i make it (Admin_ID) foreign key in Dealer table.

Uday P.Singh 15-Jun-11 12:32pm

u have to insert admin_id values of Administrator table in dealer table admin_id field, but make sure u have make it cascade at insert or update.

Sweety Khan 15-Jun-11 15:10pm

ok tell me i m saying right or not. there is a variable that has the value which i have to put in Admin_ID column of dealer table. so i just put the value in that column using insert command????

Uday P.Singh 16-Jun-11 3:49am

does that value also exists in Admin_ID column of Administer table?

Sweety Khan 15-Jun-11 15:14pm

n i have to make that variable as global variable to access it. is that ok?

Sweety Khan 16-Jun-11 4:33am

yup

Uday P.Singh 16-Jun-11 7:30am

then its fine to use that value to put in Admin_ID column of dealer table.

Sweety Khan 16-Jun-11 15:33pm

oki thanx:)