KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I am just a begginer on C# so i need too much help. Now the problem is that i have designed a windows form in which there are many fields like first name, last name, address etc. Now i want to do is that when i fill the form and click insert button all the information goes into database. Does anyone know how to do that? private void button1_Click(object sender, System.EventArgs e) { string connetionString = null; SqlConnection cnn ; SqlDataAdapter adapter = new SqlDataAdapter(); string sql = null; connetionString = "Data Source=UMAIR;Initial Catalog=Air; Trusted_Connection=True;" ; cnn = new SqlConnection(connetionString); sql = "insert into Main (Firt Name, Last Name) values(textbox2.Text,textbox3.Text)"; try { cnn.Open(); adapter.InsertCommand = new SqlCommand(sql, cnn); adapter.InsertCommand.ExecuteNonQuery(); MessageBox.Show ("Row inserted !! "); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
Tags (comma-separated)
Save Edits
Cancel