62,243
社区成员




private void BindGrid()
{
DataSet table = GetDataTable();
Grid1.DataSource = table;
Grid1.DataBind();
}
private DataSet GetDataTable()
{
DataSet source = new DataSet();
DataSet source1, source2;
DataSet source3 = new DataSet();
SqlParameter[] cs4 = new SqlParameter[4];
cs4[0] = new SqlParameter("@kuangchangId", kuangchangId);
cs4[1] = new SqlParameter("@sTime", sTime);
cs4[2] = new SqlParameter("@eTime", eTime);
cs4[3] = new SqlParameter("@customId", customId);
sqlstring = "select id,sellId,printId,productId,productPrice,totalMoney,carId,carMz,carJz,productFs,sellTime from KcSell where kuangchangId=@kuangchangId and checked=1 and customId=@customId and sellTime >= @sTime and sellTime <= @eTIme";
source1 = SqlHelper.ExecuteDataset(SqlHelper.connectionString, CommandType.Text, sqlstring, cs4);
source3.Tables.Add();
source3.Tables[0].Columns.Add("dTime", typeof(string));
source3.Tables[0].Columns.Add("dId", typeof(string));
source3.Tables[0].Columns.Add("dPid", typeof(string));
source3.Tables[0].Columns.Add("productName", typeof(string));
source3.Tables[0].Columns.Add("productPrice", typeof(string));
source3.Tables[0].Columns.Add("carName", typeof(string));
source3.Tables[0].Columns.Add("carMz", typeof(string));
source3.Tables[0].Columns.Add("carJz", typeof(string));
source3.Tables[0].Columns.Add("productFs", typeof(string));
source3.Tables[0].Columns.Add("totalMoney", typeof(string));
source3.Tables[0].Columns.Add("inMoney", typeof(string));
source3.Tables[0].Columns.Add("leaveMoney", typeof(string));
for (int i = 0; i < source1.Tables[0].Rows.Count; i++)
{
DataRow dr = source3.Tables[0].NewRow();
dr[0] = source1.Tables[0].Rows[i][10];
dr[1] = source1.Tables[0].Rows[i][1];
dr[2] = source1.Tables[0].Rows[i][2];
dr[3] = Kcc.getProductName(source1.Tables[0].Rows[i][3].ToString());
dr[4] = source1.Tables[0].Rows[i][4];
dr[5] = Kcc.getCarName(source1.Tables[0].Rows[i][6].ToString());
dr[6] = source1.Tables[0].Rows[i][7];
dr[7] = source1.Tables[0].Rows[i][8];
dr[8] = source1.Tables[0].Rows[i][9];
dr[9] = source1.Tables[0].Rows[i][5];
source3.Tables[0].Rows.Add(dr);
}
return source3;
}
DataTable dt;
DataSet source1 = new DataSet();
SqlParameter[] cs4 = new SqlParameter[4];
cs4[0] = new SqlParameter("@kuangchangId", kuangchangId);
cs4[1] = new SqlParameter("@sTime", sTime);
cs4[2] = new SqlParameter("@eTime", eTime);
cs4[3] = new SqlParameter("@customId", customId);
sqlstring = "select id,sellId,printId,productId,productPrice,totalMoney,carId,carMz,carJz,productFs,sellTime from KcSell where kuangchangId=@kuangchangId and checked=1 and customId=@customId and sellTime >= @sTime and sellTime <= @eTIme";
source1 = SqlHelper.ExecuteDataset(SqlHelper.connectionString, CommandType.Text, sqlstring, cs4);
dt = new DataTable("Name");//这里是你的表名
dt.Columns.Add("dTime", typeof(string));
dt.Columns.Add("dId", typeof(string));
dt.Columns.Add("dPid", typeof(string));
dt.Columns.Add("productName", typeof(string));
dt.Columns.Add("productPrice", typeof(string));
dt.Columns.Add("carName", typeof(string));
dt.Columns.Add("carMz", typeof(string));
dt.Columns.Add("carJz", typeof(string));
dt.Columns.Add("productFs", typeof(string));
dt.Columns.Add("totalMoney", typeof(string));
dt.Columns.Add("inMoney", typeof(string));
dt.Columns.Add("leaveMoney", typeof(string));
for (int i = 0; i < source1.Tables[0].Rows.Count; i++)
{
DataRow dr = dt.NewRow();
dr[0] = source1.Tables[0].Rows[i][10];
dr[1] = source1.Tables[0].Rows[i][1];
dr[2] = source1.Tables[0].Rows[i][2];
dr[3] = Kcc.getProductName(source1.Tables[0].Rows[i][3].ToString());
dr[4] = source1.Tables[0].Rows[i][4];
dr[5] = Kcc.getCarName(source1.Tables[0].Rows[i][6].ToString());
dr[6] = source1.Tables[0].Rows[i][7];
dr[7] = source1.Tables[0].Rows[i][8];
dr[8] = source1.Tables[0].Rows[i][9];
dr[9] = source1.Tables[0].Rows[i][5];
dt.Rows.Add(dr);
}
return source3.Tables.Add(dt);
要不就改成这样。
DataSet table = GetDataTable();
改为:DataSet table = this.GetDataTable(); 试试!