conn.Open()与conn.Close()应该写在循环,还是应该写在循环内呀???
void ffi()
{
...
for(int cd=0;cd<cclass.Length;cd++)
{
string insertcmx="insert into ktb values('"+bj[cd].ToString().Trim()+"','"+rs[cd].ToString().Trim()+"')";
SqlCommand insmx=new SqlCommand(insertcmx,conn);
conn.Open();
inscmx.ExecuteNonQuery();
conn.Close();
}
}void ffw()
{
...
conn.Open();
for(int cd=0;cd<cclass.Length;cd++)
{
string insertcmx="insert into ktb values('"+bj[cd].ToString().Trim()+"','"+rs[cd].ToString().Trim()+"')";
SqlCommand insmx=new SqlCommand(insertcmx,conn);
inscmx.ExecuteNonQuery();
}
conn.Close();
}
void ffi()
{
...
for(int cd=0;cd<cclass.Length;cd++)
{
string insertcmx="insert into ktb values('"+bj[cd].ToString().Trim()+"','"+rs[cd].ToString().Trim()+"')";
SqlCommand insmx=new SqlCommand(insertcmx,conn);
conn.Open();
inscmx.ExecuteNonQuery();
conn.Close();
}
}void ffw()
{
...
conn.Open();
for(int cd=0;cd<cclass.Length;cd++)
{
string insertcmx="insert into ktb values('"+bj[cd].ToString().Trim()+"','"+rs[cd].ToString().Trim()+"')";
SqlCommand insmx=new SqlCommand(insertcmx,conn);
inscmx.ExecuteNonQuery();
}
conn.Close();
}
个人意见,仅供参考。
out