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

Question

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();

Akshay Shedwad · Answer

Your connection string is wrong. Replace intial catalog with AttachDbFilename= 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/

Rajanikant Hawaldar · Answer

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/

Jignesh Kumar · Answer

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 Beg · Answer

Hey it's a problem with your connectionstring. Check it properly and modify it then try it will work perfectly. Thanks.