strSQL= string.Format( " Select Top 1 * From ReceivingDetailed Where ReceivingDetailedID= {0}",intTempID.ToString());
SqlDataAdapter apd = new SqlDataAdapter(strSQL,jlDataBase.cnnDataBase);
apd.Fill(dt,"tblReceivingDetailed");
SqlCommandBuilder cbd = new SqlCommandBuilder(apd);
bool blnIsNewD =(dt.Tables["tblReceivingDetailed"].Rows.Count ==0);
DataRow drd;
if (blnIsNewD)
{
apd.InsertCommand =cbd.GetInsertCommand();
drd= dt.Tables["tblReceivingDetailed"].NewRow();
}
else
{
apd.UpdateCommand =cbd.GetUpdateCommand();
drd= dt.Tables["tblReceivingDetailed"].Rows[0];
}
drd["ReceivingID"]=mintID;
if (blnIsNewD) //新增信息
{
dt.Tables["tblReceivingDetailed"].Rows.Add(drd);
drd.EndEdit();
apd.Update(dt,"tblReceivingDetailed");
}
else
{
drd.EndEdit();
apd.Update(dt,"tblReceivingDetailed");
}
SqlDataAdapter apd = new SqlDataAdapter(strSQL,jlDataBase.cnnDataBase);
apd.Fill(dt,"tblReceivingDetailed");
SqlCommandBuilder cbd = new SqlCommandBuilder(apd);
bool blnIsNewD =(dt.Tables["tblReceivingDetailed"].Rows.Count ==0);
DataRow drd;
if (blnIsNewD)
{
apd.InsertCommand =cbd.GetInsertCommand();
drd= dt.Tables["tblReceivingDetailed"].NewRow();
}
else
{
apd.UpdateCommand =cbd.GetUpdateCommand();
drd= dt.Tables["tblReceivingDetailed"].Rows[0];
}
drd["ReceivingID"]=mintID;
if (blnIsNewD) //新增信息
{
dt.Tables["tblReceivingDetailed"].Rows.Add(drd);
drd.EndEdit();
apd.Update(dt,"tblReceivingDetailed");
}
else
{
drd.EndEdit();
apd.Update(dt,"tblReceivingDetailed");
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货