我是从excel中导入数据后,进行下面的代码操作,但是不知道为什么每次运行数据库表的长度就会增加,我的本意是不增加,只想更改其中某一列的数据,求问怎么改才能不改变数据长度。
string sqlconn = "Data Source=caobin-pc;DataBase=mydb_2;integrated security = SSPI";
string tablename = "Table_1";
using (SqlConnection coo = new SqlConnection(sqlconn))
{
coo.Open();
SqlDataAdapter myDataAdapter = new SqlDataAdapter("select * from "+ tablename +"", coo);
DataSet dss = new DataSet();
myDataAdapter.Fill(dss, tablename);
//DataTable mytable = dss.Tables[tablename];
DataRow[] drr = dss.Tables[0].Select();
for (int j = 0; j < drr.Length; j++)
{
if (Convert.ToInt32(drr[j]["SSTagLine"]) <= 20 && Convert.ToInt32(drr[j]["SSTagLine"])!=null)
{
drr[j]["SSTagLine"] = Convert.ToInt32(drr[j]["SSTagLine"]) * 2 + 3;
}
else
{
break;
}
}
SqlCommandBuilder myssqlcom = new SqlCommandBuilder(myDataAdapter);
myDataAdapter.Update(dss, tablename);
coo.Close();
}
string sqlconn = "Data Source=caobin-pc;DataBase=mydb_2;integrated security = SSPI";
string tablename = "Table_1";
using (SqlConnection coo = new SqlConnection(sqlconn))
{
coo.Open();
SqlDataAdapter myDataAdapter = new SqlDataAdapter("select * from "+ tablename +"", coo);
DataSet dss = new DataSet();
myDataAdapter.Fill(dss, tablename);
//DataTable mytable = dss.Tables[tablename];
DataRow[] drr = dss.Tables[0].Select();
for (int j = 0; j < drr.Length; j++)
{
if (Convert.ToInt32(drr[j]["SSTagLine"]) <= 20 && Convert.ToInt32(drr[j]["SSTagLine"])!=null)
{
drr[j]["SSTagLine"] = Convert.ToInt32(drr[j]["SSTagLine"]) * 2 + 3;
}
else
{
break;
}
}
SqlCommandBuilder myssqlcom = new SqlCommandBuilder(myDataAdapter);
myDataAdapter.Update(dss, tablename);
coo.Close();
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货