Home > database >  C # how to submit table-valued parameter binary data?
C # how to submit table-valued parameter binary data?

Time:04-07

Stored procedure by table-valued parameters submitted to the database commands,
 DataTable table=new ();//in c # to build table-valued parameter 
Table. The Columns. The Add (new DataColumn (" key ", typeof (binary)));//this way how the type of binary expression?
Table. The Columns. The Add (new DataColumn (" address ", typeof (string)));
 when fill the table foreach (var members assembled in) 
{
DataRow line=table. NewRow ();
Line [0]=???????//members. The key is to a byte [32] types of data, how to convert it to a 256 - bit binary number?
Line [1]=members. Address;
Table Rows. The Add (line);
}
will eventually become into such a TABLE in the SQL type
 CREATE TABLE [dbo] [TABLE] (
[key] [binary] (256), NULL,
[address]] to [char] (40) NULL
)
  • Related