Insert Data In database

Question

0.00/5 (No votes)

See more:

Friends as u know I am new to c# and has a very poor knowledge of c#

In my application I have three contact box.

I want to insert this 3 box value in my contact table but not column wisei want to insert each text box value in particular row

Please any one help me how is it possible.

Posted 16-Jul-13 1:31am

Er Bhargav Dudani

Add a Solution

Comments

[no name] 16-Jul-13 7:32am

You connect to whatever database you are using, write an INSERT or UPDATE query and execute the query.

Er Bhargav Dudani 16-Jul-13 7:56am

will u please explain me with demo example

[no name] 16-Jul-13 8:07am

No. You have not provided nearly enough information to be able to do that. Besides that, you need to try yourself.

Naz_Firdouse 16-Jul-13 7:36am

rowwise insertion in the sense....please elaborate

Er Bhargav Dudani 16-Jul-13 7:46am

let me explain with demo

my table have only 2 columns 1 is id and 2 is value

in which id is auto incremented,

my form have n number of text box so when I press on insert button then my 1st text box value will be inserted with id 1,second text box value inserted with id=2and so on

SrinivasTiru 16-Jul-13 7:37am

You want to insert in Contact Column in a table? Then use Insert Command with Where Clause

Er Bhargav Dudani 16-Jul-13 7:42am

no sir I have already contact column in my data base but.
but I want to insert 1st text box 's value in first row after then 2 text box value in 2 row

Er Bhargav Dudani 16-Jul-13 7:44am

my table have id column an it is auto incremented so my 1 st text box value have id=1,and 2nd text box value have id=2

2 solutions

Solution 2

1. Connect to Database
2. Give sql command like

C#

string sql= "insert into tablename (Contact) values (?p1) where contactid=values";
SqlCommand cmd = new SqlCommand(sql,con);
cmd.Parameters.AddWithValue("?p1",TextBox1.Text);
cmd.ExecuteNonQuery();
con.Close();

Posted 16-Jul-13 1:39am

SrinivasTiru

Updated 16-Jul-13 2:07am

v2

Comments

Er Bhargav Dudani 16-Jul-13 8:16am

Sorry but it gives me following error

Incorrect syntax near '?'

SrinivasTiru 16-Jul-13 9:07am

try like this
string sql= "insert into tablename (Contact) values (?p1) where contactid=values;";

As you mentioned in the comment, if there are N number of TextBox, then you may have to go through loop for inserting into the table

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)

**Nirav Prabtani** · Accepted Answer · 2013-07-16T01:36:00

C#

try
    {
//your database connection string.
        string connectionString = @"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Customers.mdf;Integrated Security=True;User Instance=True";

        using (SqlConnection connection = new SqlConnection(connectionString))
        using (SqlCommand command = connection.CreateCommand())
        {
            command.CommandText = "INSERT INTO TableName(ColumnName1, ColumnName2, ColumnName3) VALUES (@value1, @value2, @value3)";

            command.Parameters.AddWithValue("@value1", ContactBox1.Text);
            command.Parameters.AddWithValue("@value2", ContactBox2.Text);
            command.Parameters.AddWithValue("@value3", ContactBox3.Text);
           

            connection.Open();
            command.ExecuteNonQuery();
        }
    }
    catch (SqlException ex)
    {
        Console.WriteLine(ex.Message);
    }