private void BindOperationGrid()
{
lblGType.Text = Session["GType"].ToString();
int gType = int.Parse(Session["GTypeId"].ToString());
SqlConnection conn = new SqlConnection(DbConnect.x);
DataTable dt = new DataTable();
try
{
conn.Open();
SqlCommand cmd1 = new SqlCommand("select b.OperationName,a.SMV,a.MachineQty,a.ManQty from tblGtypeProcess a join tblProcess b on a.Process = b.Id where GType = " + gType, conn);
SqlDataAdapter da1 = new SqlDataAdapter(cmd1);
da1.Fill(dt);
//OperationGridView.DataMember = "tblOperation";
OperationGridView.DataSource = dt;
OperationGridView.DataBind();
}
catch (Exception ex)
{
Response.Write("Error Occured: " + ex.ToString());
}
finally
{
conn.Close();
//dt.Clear();
//ds.Dispose();
}
}
private void BindOperationGrid()
{
SqlConnection conn = new SqlConnection(DbConnect.x);
DataTable dt = new DataTable();
try
{
SqlCommand cmd = new SqlCommand("GET_OPERATION_DATA", conn);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter adp = new SqlDataAdapter(cmd);
adp.Fill(dt);
OperationGridView.DataSource = dt;
OperationGridView.DataBind();
//if (dt.Rows.Count > 0)
//{
// OperationGridView.DataSource = null;
// OperationGridView.DataBind();
//}
}
catch (Exception ex)
{
Response.Write("Error Occured: " + ex.ToString());
}
finally
{
//dt.Clear();
//ds.Dispose();
}
}
protected void GetGType_SelectedIndexChanged(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection(DbConnect.x);
conn.Open();
SqlCommand cmd1 = new SqlCommand("select b.id, b.OperationName,a.SMV,a.MachineQty,a.ManQty from tblGtypeProcess a join tblProcess b on a.Process = b.Id where GType = '" + GetGType.SelectedItem.Value + "'", conn);
SqlDataAdapter da1 = new SqlDataAdapter(cmd1);
DataSet ds = new DataSet();
da1.Fill(ds);
//OperationGridView.DataMember = "tblOperation";
OperationGridView.DataSource = ds;
OperationGridView.DataBind();
conn.Close();
}
