SQL Insert

[wwechopper1]

What SQLCommand method executes an SQL Insert statement?

 

[AlexCuse]

Have a look at this:

http://www.codeguru.com/Csharp/Csharp/cs_data/article.php/c4211/

You have not really given enough information to get an answer here, most importantly how are you connecting the database?

By the way, this was the second result from Google for the search string 'SQL insert C#'.

Hope it helps,

Alex

Ignorance of certain subjects is a great part of wisdom

 

[mjjks]

There are many ways of doing it (client side, stored procedure, etc.).

Here's one way, though not best (SQL injection if you're using web). Add try/catch to trap errors.

SqlConnection oConn = new SqlConnection();
            oConn.ConnectionString = "your database/logon credentials";
            oConn.Open();

            SqlCommand cmd = new SqlCommand();
            cmd.Connection = oConn;
            cmd.CommandText = "insert into myTable some data";
            cmd.ExecuteNonQuery();

 

[wwechopper1]

mjjks,

Sorry, Im new at this. How do i change what table the code is accessing. and do i have to change anything in this line

cmd.CommandText = "insert into myTable some data";

 

[AlexCuse]

You want to replace "insert into myTable some data" with the SQL statement you want to execute.



Ignorance of certain subjects is a great part of wisdom

 

[wwechopper1]

Like I said, im new at this, what would the SQL Statement be?
Thanks

 

[AlexCuse]

The SQL Statement to insert to your table? Something like "insert into myTable some data" only a little more like "insert into myTable select \"" + Convert.ToString(formControl.Value) + "\""



Ignorance of certain subjects is a great part of wisdom

 

[mjjks]

Yes, you would change it to reflect your particular SQL insert statement. Here are some basics:

http://www.w3schools.com/sql/sql_insert.asp