How can I insert data into a table using c#?

Hil Isabelle

Hello everyone!

I've got a simple table 'Table' in a simple database 'Database1' with 2 rows (Id,Chemin) and I'm trying to insert data into my table but the opening of the connection to the database doesn't work (con.Open()). Can someone tell me why and help me please ? The code is below :

SqlConnection con = new SqlConnection(@"Data Source=.\SQLEXPRESS;Initial Catalog=Database1;Integrated Security=True");
SqlCommand cmd = new SqlCommand("sp_insert", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Chemin", textBox1.Text); //cmd.Parameters.AddWithValue("@email", textBox2.Text);
con.Open();
int i = cmd.ExecuteNonQuery();
con.Close();

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Akshay Shedwad6y ago
Accepted answer
Your connection string is wrong. Replace intial catalog with AttachDbFilename=< put database directory link > like

SqlConnection con = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database1.mdf;Integrated Security=True;User Instance=True");

For More information,

https://www.c-sharpcorner.com/UploadFile/009464/insert-data-into-database-in-window-form-using-C-Sharp/
Jignesh Kumar6y ago
Hi,

Please have a look at connectionstring.
https://www.c-sharpcorner.com/code/3379/connection-strings-in-web-config-file-using-asp-net.aspx
Salman Beg6y ago
Hey it's a problem with your connectionstring. Check it properly and modify it then try it will work perfectly. Thanks.
Rajanikant Hawaldar6y ago
If con.Opeb() throws exception then connection string is wrong.
https://www.c-sharpcorner.com/UploadFile/009464/insert-data-into-database-in-window-form-using-C-Sharp/
https://www.c-sharpcorner.com/UploadFile/18585c/insert-data-in-sql-server-from-front-end-by-using-windows-ap/
http://www.simplylearnprogramming.com/insert-update-delete-select-data-sqlserver-csharp/41
https://docs.microsoft.com/en-us/dotnet/api/system.data.sqlclient.sqlconnection.connectionstring?view=dotnet-plat-ext-3.1 https://www.connectionstrings.com/sql-server/