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