SqlConnection con=db.createcon();
SqlDataAdapter sda=new SqlDataAdapter ("select * from ReturnVisit",con);
DataSet ds=new DataSet();
sda.Fill(ds,"ReturnVisit");
con.Close();
ds.Clone();
for(int i=0;i<ds.Tables["ReturnVisit"].Rows.Count;i++)
{
con.Open();
string a=Convert.ToString(ds.Tables["ReturnVisit"].Rows[i]["维修单号"]);
SqlDataAdapter a11 =new SqlDataAdapter ("select * from TotalVisit where 维修单号="+a,con);
DataSet ds1=new DataSet();
a11.Fill(ds1,"TotalVisit");
if(ds1.Tables["TotalVisit"].Rows.Count>0)
{
SqlCommand cmd=new SqlCommand ("Delete from ReturnVisit where 维修单号="+a,con);
cmd.ExecuteNonQuery();
}
}提示::::::::
将数据类型 nvarchar 转换为 numeric 时出错源错误:
行 31: SqlDataAdapter a11 =new SqlDataAdapter ("select * from TotalVisit where 维修单号="+a,con);
行 32: DataSet ds1=new DataSet();
行 33: a11.Fill(ds1,"TotalVisit");
SqlDataAdapter sda=new SqlDataAdapter ("select * from ReturnVisit",con);
DataSet ds=new DataSet();
sda.Fill(ds,"ReturnVisit");
con.Close();
ds.Clone();
for(int i=0;i<ds.Tables["ReturnVisit"].Rows.Count;i++)
{
con.Open();
string a=Convert.ToString(ds.Tables["ReturnVisit"].Rows[i]["维修单号"]);
SqlDataAdapter a11 =new SqlDataAdapter ("select * from TotalVisit where 维修单号="+a,con);
DataSet ds1=new DataSet();
a11.Fill(ds1,"TotalVisit");
if(ds1.Tables["TotalVisit"].Rows.Count>0)
{
SqlCommand cmd=new SqlCommand ("Delete from ReturnVisit where 维修单号="+a,con);
cmd.ExecuteNonQuery();
}
}提示::::::::
将数据类型 nvarchar 转换为 numeric 时出错源错误:
行 31: SqlDataAdapter a11 =new SqlDataAdapter ("select * from TotalVisit where 维修单号="+a,con);
行 32: DataSet ds1=new DataSet();
行 33: a11.Fill(ds1,"TotalVisit");
慢了。。你的维修单号 a要说明是字符形的。所以要加"'"来说明