Hi All,
Is there another way to optimize the below code? I need to check two columns values of a database table.
if (!Page.IsPostBack)
{
string constr = ConfigurationManager.ConnectionStrings["DataConString"].ConnectionString;
SqlConnection con = new SqlConnection(constr);
SqlCommand cmd;
con.Open();
string queryhasgroup = "SELECT konferanse_Register.HasCourseGroup FROM konferanse_Register WHERE CourseID =@CourseID";
string queryhasmiddag = "SELECT konferanse_Register.HasCourseMiddag FROM konferanse_Register WHERE CourseID =@CourseID";
cmd = new SqlCommand(queryhasgroup, con);
cmd.Parameters.AddWithValue("@CourseID", txtCourseID.Text.Trim());
string valueCourseStatus = cmd.ExecuteScalar() as string;
cmd = new SqlCommand(queryhasmiddag, con);
cmd.Parameters.AddWithValue("@CourseID", txtCourseID.Text.Trim());
string valueCourseStatusMiddag = cmd.ExecuteScalar() as string;
con.Close();
if ((valueCourseStatus != null) && valueCourseStatus.Equals("No"))
{
hideThis.Visible = false;
hideThis2.Visible = false;
}
if ((valueCourseStatusMiddag != null) && valueCourseStatusMiddag.Equals("No"))
{
hideThisMiddag.Visible = false;
hideThis2Middag.Visible = false;
}
con.Dispose();
}
Thank you very much