CREATETYPE dbo.TestDataTypeAS TABLE
(TableName nvarchar(50),
Contents nvarchar(max) ) --可以为表中的某一些字段
ifexists (select * from sysobjects where type = 'P' and name = 'spImportTableSqlByTable') drop procedure dbo.spImportTableSqlByTable;
go
CREATEprocedure spImportTableSqlByTable @InsertData TestDataTypeREADONLYas--@InsertData为C#中要传入的表参数
begin endinsert into TableSql (TableName,Contents)
select TableName,Contents
from @InsertData
go
//c#调用该存储过程:
DataTable dt = new DataTable();
dt.Columns.Add("TableName", Type.GetType("System.String"));
dt.Columns.Add("Contents", Type.GetType("System.String"));
foreach (string line in lines)
{
dt.Rows.Add(index,line);
index++;
}
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandText = "spImportTableSqlByTable";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@InsertData", SqlDbType.Structured);
cmd.Parameters[0].Value = dt;
cmd.ExecuteNonQuery();
con.Close();
联系客服