以下语句实现excel文件数据导入sqlserver,想实现这样的功能:sqlserver的表中字段“专业”为int类型,判断当rk_zhuanye的字符为“机械”时就向专业字段写入1,当rk_zhuanye的字符为“电气”时就向专业字段写入2,请问如何修改?
for (int i = 0; i < dr.Length; i++)
{
string rk_xinghao = dr[i]["型号"].ToString();
string rk_guige = dr[i]["规格"].ToString();
string rk_zhuanye = dr[i]["专业"].ToString(); insert into ruku (型号,规格,专业) values('" + ck_xinghao + "','" + ck_guige + "','" + ck_zhuanye + "') SqlCommand cmd2 = new SqlCommand(insertstr2, cn2);
try
{
cmd2.ExecuteNonQuery();
}
catch (MembershipCreateUserException ex)
{
Response.Write("<script>alert('导入内容:" + ex.Message + "')</script>");
}
}
for (int i = 0; i < dr.Length; i++)
{
string rk_xinghao = dr[i]["型号"].ToString();
string rk_guige = dr[i]["规格"].ToString();
string rk_zhuanye = dr[i]["专业"].ToString(); insert into ruku (型号,规格,专业) values('" + ck_xinghao + "','" + ck_guige + "','" + ck_zhuanye + "') SqlCommand cmd2 = new SqlCommand(insertstr2, cn2);
try
{
cmd2.ExecuteNonQuery();
}
catch (MembershipCreateUserException ex)
{
Response.Write("<script>alert('导入内容:" + ex.Message + "')</script>");
}
}
以下语句实现excel文件数据导入sqlserver,想实现这样的功能:sqlserver的表中字段“专业”为int类型,判断当rk_zhuanye的字符为“机械”时就向专业字段写入1,当rk_zhuanye的字符为“电气”时就向专业字段写入2,请问如何修改?
for (int i = 0; i < dr.Length; i++)
{
string rk_xinghao = dr[i]["型号"].ToString();
string rk_guige = dr[i]["规格"].ToString();
string rk_zhuanye = dr[i]["专业"].ToString(); string insertstr2=insert into ruku (型号,规格,专业) values('" + ck_xinghao + "','" + ck_guige + "','" + ck_zhuanye + "') SqlCommand cmd2 = new SqlCommand(insertstr2, cn2);
try
{
cmd2.ExecuteNonQuery();
}
catch (MembershipCreateUserException ex)
{
Response.Write("<script>alert('导入内容:" + ex.Message + "')</script>");
}
}
==or==
int rk_zhuanye;
switch(dr[i]["专业"].ToString())
{
case "机械"
rk_zhuanye=1;
break;
case "电气":
rk_zhuanye=2;
break;
default:
rk_zhuanye=0;
break;
}