Advertisement
Guest User

Untitled

a guest
Aug 20th, 2014
199
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.64 KB | None | 0 0
  1. cmd.Parameters.AddWithValue("@StudentName", txtName.Text);
  2. cmd.Parameters.AddWithValue("@ContactNo", txtSNo.Text);
  3. cmd.Parameters.AddWithValue("@FathersNo", txtFNo.Text);
  4. cmd.Parameters.AddWithValue("@MothersNo", txtMNo.Text);
  5. cmd.Parameters.AddWithValue("@Email", txtEID.Text);
  6. cmd.ExecuteNonQuery();
  7.  
  8. var data = new Dictionary<string, TextBox>
  9. {
  10. {"@StudentName", txtName},
  11. {"@ContactNo", txtSNo},
  12. {"@FathersNo", txtFNo},
  13. {"@MothersNo", txtMNo},
  14. {"@Email", txtEID}
  15. };
  16.  
  17. foreach (var kvp in data)
  18. {
  19. cmd.Parameters.AddWithValue(kvp.Item1, kvp.Item2);
  20. }
  21.  
  22. cmd.ExecuteNonQuery();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement