Answers for "executenonquery error"

C#
0

How to solve error in ExecuteNonQuery() in asp.net

SqlConnection con = new SqlConnection();
con.ConnectionString = @"Data Source = (LocalDB)MSSQLLocalDB; AttachDbFilename = C:UsersHarryDocumentsVisual Studio 2015WebSitesWebSite2App_DataDatabase.mdf; Integrated Security = True";
con.Open();

// insert command 
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandText="INSERT INTO firsttb VALUES ( @n , @p ) ";
cmd.CommandType = System.Data.CommandType.Text;
cmd.Parameters.AddWithValue("@n",TextBox1.Text);
cmd.Parameters.AddWithValue("@p", TextBox2.Text);

cmd.ExecuteNonQuery();

con.Close();
Posted by: Guest on June-13-2020

C# Answers by Framework

Browse Popular Code Answers by Language