private void BindData()
{
//at = SpringUtil.at();
String sql = "SELECT * FROM ReuseTech ";
sql += " WHERE Type='2' ";
if (!WasteItem.SelectedValue.Equals("Z"))
{
sql += "and WasteItem='" + WasteItem.SelectedValue + "'";
}
if (!TechItem.SelectedValue.Equals("Z"))
{
sql += "and TechItem='" + TechItem.SelectedValue + "'";
}
//DataSet ds = new DataSet();
//at.DataSetFill(ds, CommandType.Text, sql);
OleDbCommand cmd = new OleDbCommand(sql);
DataSet ds = SQLUtil.QueryDS(cmd);
ReuseGrid.DataSource = ds;
ReuseGrid.DataKeyNames = new string[] { "Id" };
ReuseGrid.DataBind();
if (ds.Tables[0].Rows.Count > 0)
{
Panel1.Visible = false;
}
else
{
Panel1.Visible = true;
}
}
private void BindGrid()
{
try
{
//at = SpringUtil.at();
String sql = "SELECT r.Id,r.Patent,r.ResearchItem,r.ReuseName,r.TechItem,r.TechName,r.TechOther,r.UserName,r.WasteItem,r.WasteName,r.WasteOther ";
sql += " from ReuseTech r ";
sql += " where r.UserName=@param1 order by r.Id desc ";
//IDbParameters parameters = at.CreateDbParameters();
//parameters.Add("param1", OleDbType.VarChar).Value = User.Identity.Name;
//DataSet ds = new DataSet();
//at.DataSetFillWithParameters(ds, CommandType.Text, sql, parameters);
OleDbCommand cmd = new OleDbCommand(sql);
cmd.Parameters.Add("param1", OleDbType.VarChar).Value = User.Identity.Name;
cmd.CommandType = CommandType.Text;
DataSet ds = SQLUtil.QueryDS(cmd);
ReuseGrid.DataSource = ds;
ReuseGrid.DataKeyNames = new string[] { "Id" };
ReuseGrid.DataBind();
}
catch (Exception err)
{
Response.Write(err.ToString());
}
}
