public DataSet FindOrderdetailbyID(cOrderInfo order, string tbName)
{
SqlParameter[] prams = {
MakeInParam("@orderid", SqlDbType.Int, 5,order.OrderID+"%"),
};
string ii = "select * from PUOrderDetails where OrderID = @orderID";
Open();
SqlDataAdapter da = new SqlDataAdapter(ii, con);
// 创建DataSet
DataSet ds = new DataSet();
//填充,第一个参数是要填充的dataset对象,第二个参数是填充dataset的datatabble
da.Fill(ds, "PUOrderDetails");
return ds;
{
SqlParameter[] prams = {
MakeInParam("@orderid", SqlDbType.Int, 5,order.OrderID+"%"),
};
string ii = "select * from PUOrderDetails where OrderID = @orderID";
Open();
SqlDataAdapter da = new SqlDataAdapter(ii, con);
// 创建DataSet
DataSet ds = new DataSet();
//填充,第一个参数是要填充的dataset对象,第二个参数是填充dataset的datatabble
da.Fill(ds, "PUOrderDetails");
return ds;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货