Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SqlConnection con=new SqlConnection();
- con.Open();
- SqlCommand cmd=new SqlCommand("SPName",con);
- DataTable dataTable = new DataTable("vpTableGuid");
- dataTable.Columns.Add("id1", typeof(Guid));
- dataTable.Columns.Add("rowNum", typeof(Int32));
- dataTable.Rows.Add(Guid.NewGuid(),1);
- dataTable.Rows.Add(Guid.NewGuid(),2);
- dataTable.Rows.Add(Guid.NewGuid(),3);
- SqlParameter param = new SqlParameter("@evaluatorList", dataTable);
- param.SqlDbType = SqlDbType.Structured;
- param.TypeName = "dbo.vpTableGuid";
- command.Parameters.Add(param);
- command.ExecuteNonQuery();
- id1 UNIQUEIDENTIFIER DEFAULT NEWID() PRIMARY KEY
- dataTable.Columns.Add("id1", typeof(Guid));
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement