Advertisement
Guest User

Untitled

a guest
Mar 18th, 2019
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.75 KB | None | 0 0
  1. public int ExecuteNonQuery(string sSql, List<SqlParameter> pList)
  2. {
  3. open();
  4. SqlCommand cmd = new SqlCommand(sSql, mConeccion);
  5.  
  6. foreach(var p in pList)
  7. {
  8. cmd.Parameters.Add(p);
  9. }
  10.  
  11. int rowAfected = cmd.ExecuteNonQuery();
  12.  
  13. return rowAfected;
  14. }
  15.  
  16. string sSql = "INSERT INTO Dueño (campo1, campo2, LocalidadId) VALUES (@param1, @param2, @localidad)";
  17.  
  18. List<SqlParameter> pList = new List<SqlParameter>();
  19.  
  20. SqlParameter p1 = new SqlParamter("@param1", TextBox1.Text);
  21. pList.Add(p1);
  22.  
  23. SqlParameter p2 = new SqlParamter("@param2", TextBox2.Text);
  24. pList.Add(p2);
  25.  
  26. SqlParameter p3 = new SqlParamter("@localidad", Convert.ToInt32(cmdLocalidades.SelectedValue));
  27. pList.Add(p3);
  28.  
  29. int rowAfected = ExecuteNonQuery(sSql, pList);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement