110,561
社区成员
发帖
与我相关
我的任务
分享
private void BindDatatable(string sql)
{
string comboxnew = comboBox1.SelectedItem.ToString();
try
{
con = conn();
adap = new SqlDataAdapter(sql, con);
SqlCommandBuilder scb = new SqlCommandBuilder(adap);
if (dt == null)
{
dt = new DataTable();
}
dt.PrimaryKey = new DataColumn[] { dt.Columns["id"] };
adap.FillSchema(dt, SchemaType.Mapped);
adap.Fill(dt);
if (dt.Rows.Count > 0)
{
Thread newthr = new Thread(new ThreadStart(getdate_datatale));
newthr.Start();
}
}
catch (Exception ep)
{
errlog(ep.Message);
}
}
private void getdate_datatale()
{
try
{
for (i = 0; i < dt.Rows.Count; i++)
{
try
{
dt.Rows[i]["sendyorn"] = 1; //置标识为1,为已检索
adap.Update(dt);
}
catch (Exception ep)
{
errlog(ep.Message );
}
if (result.Equals(success))
{
try
{
string update = "update table SET state=1 WHERE id=" + dt.Rows[i]["id"];
update_sql(update);
log("成功提交数据");
}
catch (Exception ep)
{
errlog(ep.Message);
}
}
else
{
errlog("数据提交失败);
}
}
}
catch (Exception ep)
{
errlog(ep.Message );
}
finally
{
try
{
con.Close();
dt.Clear();
adap.Dispose();
}
catch (Exception ep)
{
errlog(ep.Message);
}
}
}