110,538
社区成员
发帖
与我相关
我的任务
分享
private void button1_Click(object sender, EventArgs e)
{
string sql = "insert into bx_Label(LabelID,ClassID,Label_Name,Label_Content,Description,CreatTime,isBack,isRecyle,isSys,SiteID,isShare)" +
" values (@LabelID,@ClassID,@Label_Name,@Label_Content,@Description,@CreatTime,@isBack,@isRecyle,@isSys,@SiteID,@isShare)";
SqlParameter[] parameters = {
new SqlParameter("@LabelID", SqlDbType.NVarChar),
new SqlParameter("@ClassID", SqlDbType.NVarChar),
new SqlParameter("@Label_Name", SqlDbType.NVarChar),
new SqlParameter("@Label_Content", SqlDbType.NText),
new SqlParameter("@Description", SqlDbType.NVarChar),
new SqlParameter("@CreatTime", SqlDbType.SmallDateTime),
new SqlParameter("@isBack", SqlDbType.TinyInt,1),
new SqlParameter("@isRecyle", SqlDbType.TinyInt,1),
new SqlParameter("@isSys", SqlDbType.TinyInt,1),
new SqlParameter("@SiteID", SqlDbType.NVarChar),
new SqlParameter("@isShare", SqlDbType.TinyInt,1)};
string querySQL = "select * from bx_Label where SiteID=(select top 1 siteId from bx_sys_Label order by SiteId) and classId='99999999'";
SqlConnection connection = new SqlConnection("Data Source=zhou;Initial Catalog=FooSunCMS;User ID=sa;Password=sa");
SqlCommand command = new SqlCommand(querySQL, connection);
SqlDataAdapter adapter = new SqlDataAdapter(command);
DataTable data = new DataTable();
connection.Open();//这里只打开一次连接
adapter.Fill(data);
DataRow row = null;
command = new SqlCommand(sql,connection);
//下面用循环插入标签
for (int i = 0; i < data.Rows.Count; i++)
{
row = data.Rows[i];
command.Parameters.Clear();//这句不能少,否则会报错
parameters[0].Value = RandNumber();//row[0];
command.Parameters.Add(parameters[0]);
parameters[1].Value = row[2];
command.Parameters.Add(parameters[1]);
parameters[2].Value = row[3];
command.Parameters.Add(parameters[2]);
parameters[3].Value = row[4];
command.Parameters.Add(parameters[3]);
parameters[4].Value = row[5];
command.Parameters.Add(parameters[4]);
parameters[5].Value = DateTime.Parse(row[6].ToString());
command.Parameters.Add(parameters[5]);
parameters[6].Value = byte.Parse(row[7].ToString());
command.Parameters.Add(parameters[6]);
parameters[7].Value = byte.Parse(row[8].ToString());
command.Parameters.Add(parameters[7]);
parameters[8].Value = byte.Parse(row[9].ToString());
command.Parameters.Add(parameters[8]);
parameters[9].Value = "5";
command.Parameters.Add(parameters[9]);
parameters[10].Value = DBNull.Value;
command.Parameters.Add(parameters[10]);
command.ExecuteNonQuery();
}
connection.Close();
connection.Dispose();
command.Dispose();
}
CommandType.Table