Advertisement
Guest User

Untitled

a guest
Jun 17th, 2019
66
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.69 KB | None | 0 0
  1. SqlConnection con=new SqlConnection();
  2. con.Open();
  3.  
  4. SqlCommand cmd=new SqlCommand("SPName",con);
  5.  
  6. DataTable dataTable = new DataTable("vpTableGuid");
  7.  
  8. dataTable.Columns.Add("id1", typeof(Guid));
  9. dataTable.Columns.Add("rowNum", typeof(Int32));
  10.  
  11. dataTable.Rows.Add(Guid.NewGuid(),1);
  12. dataTable.Rows.Add(Guid.NewGuid(),2);
  13. dataTable.Rows.Add(Guid.NewGuid(),3);
  14.  
  15. SqlParameter param = new SqlParameter("@evaluatorList", dataTable);
  16. param.SqlDbType = SqlDbType.Structured;
  17. param.TypeName = "dbo.vpTableGuid";
  18.  
  19. command.Parameters.Add(param);
  20.  
  21. command.ExecuteNonQuery();
  22.  
  23. id1 UNIQUEIDENTIFIER DEFAULT NEWID() PRIMARY KEY
  24.  
  25. dataTable.Columns.Add("id1", typeof(Guid));
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement