Visible GridView
I have 2 datagrid's on my page. What I'm trying to do is for certain conditions to show one or both grids. I getting an error "CS1518: Expected class, delegate, enum, interface, or struct"
Here is my code
void Page_Load(Object sender , EventArgs e)
{
if (! IsPostBack )
BindDataGrid();
}
void BindDataGrid()
{
String constring, strPatientID;
SqlConnection conEck;
strPatientID = Request.QueryString["id"];
constring = ConfigurationSettings.AppSettings["constring"];
conEck = new SqlConnection(constring);
SqlCommand cmdSql = new SqlCommand("SELECT * FROM [PatientRecord] WHERE [PatientID] =" + strPatientID, conEck);
conEck.Open();
RightGrid.DataSource = cmdSql.ExecuteReader();
RightGrid.DataBind();
conEck.Close();
conEck.Open();
LeftGrid.DataSource = cmdSql.ExecuteReader();
LeftGrid.DataBind();
conEck.Close();
ShowGrid();
}
void ShowGrid()
{
strPatientID = Request.QueryString["id"];
String constring;
SqlCommand cmdTreatment;
SqlParameter parmReturn;
SqlConnection conEzy;
int intResult;
constring = ConfigurationSettings.AppSettings["constring"];
conEzy = new SqlConnection(constring);
cmdTreatment = new SqlCommand("PatientTreatment", conEzy);
cmdTreatment.CommandType = CommandType.StoredProcedure;
parmReturn = cmdTreatment.Parameters.Add("RETURN_VALUE", SqlDbType.Int);
parmReturn.Direction = ParameterDirection.ReturnValue;
cmdTreatment.Parameters.Add("@patientid", strPatientID);
conEzy.Open();
cmdTreatment.ExecuteNonQuery();
intResult = System.Convert.ToInt32(cmdTreatment.Parameters["RETURN_VALUE"].Value);
conEzy.Close();
Cache["Treatment"] = intResult;
string treatment = Convert.ToString(Cache.Get("Treatment"));
if (treatment == 1)
{
RightGrid.Visible="true";
LeftGrid.Visible="false";
}
else if (treatment == 2)
{
LeftGrid.Visible="true";
RightGrid.Visible="false";
}
else
{
RightGrid.Visible="true";
LeftGrid.Visible="true";
}
}
}
Any suggestions?
Thanks
|
