"cmd.executenonquery() error in c#" Code Answer's
You're definitely familiar with the best coding language C# that developers use to develop their projects and they get all their queries like "cmd.executenonquery() error in c#" answered properly. Developers are finding an appropriate answer about cmd.executenonquery() error in c# related to the C# coding language. By visiting this online portal developers get answers concerning C# codes question like cmd.executenonquery() error in c#. Enter your desired code related query in the search bar and get every piece of information about C# code related question on cmd.executenonquery() error in c#.
cmd.executenonquery() error in c#
private void SaveBtn_Click(object sender, EventArgs e)
{
SqlConnection Con = new SqlConnection("Data Source=DESKTOP-BSJERV7\\YAKUBMUCK;Initial Catalog=LoginDatabase;Integrated Security=True");
SqlCommand cmd = new SqlCommand(@"INSERT INTO [dbo].[Student]
([FirstName]
,[LastName]
,[MiddleName]
,[Gender]
,[DOB]
,[Address]
,[Form]
,[Contact]
,[Parent]
,[Fee])
VALUES
('" + FirstNameTextBox.Text + "','" + LastNameTextBox.Text + "','" + MiddleNameTextBox.Text + "','" + GendercomboBox.SelectedItem.ToString() + "','" + DOBdateTimePicker.Value.Date + "','" + LComboBox.SelectedItem.ToString()+ "','" + ContactextBox.Text + "', '" + ParentTextBox.Text+ "','" + FeeTextBox.Text + "')");
Con.Open();
cmd.ExecuteNonQuery();
Con.Close();
MessageBox.Show("Save successifully");
}
How to solve error in ExecuteNonQuery() in asp.net
SqlConnection con = new SqlConnection();
con.ConnectionString = @"Data Source = (LocalDB)\MSSQLLocalDB; AttachDbFilename = C:\Users\Harry\Documents\Visual Studio 2015\WebSites\WebSite2\App_Data\Database.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();
Source: stackoverflow.com
All those coders who are working on the C# based application and are stuck on cmd.executenonquery() error in c# can get a collection of related answers to their query. Programmers need to enter their query on cmd.executenonquery() error in c# related to C# code and they'll get their ambiguities clear immediately. On our webpage, there are tutorials about cmd.executenonquery() error in c# for the programmers working on C# code while coding their module. Coders are also allowed to rectify already present answers of cmd.executenonquery() error in c# while working on the C# language code. Developers can add up suggestions if they deem fit any other answer relating to "cmd.executenonquery() error in c#". Visit this developer's friendly online web community, CodeProZone, and get your queries like cmd.executenonquery() error in c# resolved professionally and stay updated to the latest C# updates.