public void FetchRecordPending()
{
EnableControls();
string SqlPass = null;
SqlCommand Cmd = new SqlCommand();
SqlPass = "******";
Cmd = new SqlCommand(SqlPass, obj.Connection());
Cmd.CommandType = CommandType.StoredProcedure;
Cmd.Parameters.Add("@EmployeeCode", SqlDbType.VarChar, 10).Value = Session["EmpCode"];
Cmd.Parameters.Add("@Param", SqlDbType.VarChar, 20).Value = DrpLvStatus.SelectedItem.Text;
SqlDataAdapter Da = new SqlDataAdapter(Cmd);
DataSet ds = new DataSet();
Da.Fill(ds);
if (ds.Tables.Count == 0)
{
GridExtTask.DataSource = null;
GridExtTask.DataBind();
string script = "alert('No Record Found');";
ScriptManager.RegisterStartupScript(this, this.GetType(), "ServerControlScript", script, true);
return;
}
else
{
GridExtTask.DataSource = ds.Tables[0];
GridExtTask.DataBind();
}
}