Guest User

Untitled

a guest
May 25th, 2018
88
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.82 KB | None | 0 0
  1. private void savebuyers_Click(object sender, RoutedEventArgs e)
  2. {
  3. string connectionstring = null;
  4. connectionstring = "Data Source=FRANCIS;Initial Catalog=Pam Golding;Integrated Security=SSPI";
  5. SqlConnection con = new SqlConnection(connectionstring);
  6.  
  7. try
  8. {
  9. string query;
  10. query = "insert into buyers (name,number,email) values ('" + namebuyers.Text + "'," + Convert.ToInt32(numberbuyers) + ",'" + emailbuyers.Text + "')";
  11. SqlCommand command = new SqlCommand(query, con);
  12. message1.Text = "Data Saved Successfully!";
  13. con.Open();
  14. command.ExecuteNonQuery();
  15. con.Close();
  16. }
  17. catch
  18. {
  19. message1.Text = "Error While Saving Data!";
  20. }
  21. }
  22.  
  23. Convert.ToInt32(numberbuyers.Text)
Add Comment
Please, Sign In to add comment