how to insert data in sql with C#

[jaydeep1991]

hi I dont know coding to Insert data in sql with the help of C# language and I want to save data with the click event of save button

[r035198x]

http://bytes.com/topic/net/insights/...e-your-program

[jaydeep1991]

I want to use my database by query and it is sql 2008

[r035198x]

Did you read the article I linked to above?

[vijay6]

Hey jaydeep1991 take this code as example and change it as per your need. But my suggestion is read the article on the link 'r035198x' posted.

void Save_Click(object sender, EventArgs e)
{
try
{
SqlConnection con = new SqlConnection("Your Database Connection String");
SqlCommand cmd = new SqlCommand("Insert into Table_1 (Name) values (@Name)", con);
cmd.Parameters.AddWithValue("@Name", "Yourname");
cmd.ExecuteNonQuery();
 
Console.WriteLine("New row successfully inserted");
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
finally
{
con.Close();
}
}