Scribd Logo
Upload

Welcome to Scribd!

  • 14 views

    Codes

    Uploaded by

    Pooja Sisodia
    This code connects to a database, queries for course IDs starting with "IC", adds them to a dropdown list, and catches several types of exceptions, displaying error messages for each.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as DOC, PDF, TXT or read online from Scribd

    Codes

    Uploaded by

    Pooja Sisodia
    14 views2 pages
    This code connects to a database, queries for course IDs starting with "IC", adds them to a dropdown list, and catches several types of exceptions, displaying error messages for each.

    Copyright

    © Attribution Non-Commercial (BY-NC)

    Available Formats

    DOC, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This code connects to a database, queries for course IDs starting with "IC", adds them to a dropdown list, and catches several types of exceptions, displaying error messages for each.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as DOC, PDF, TXT or read online from Scribd
    Download as doc, pdf, or txt
    14 views2 pages

    Codes

    Uploaded by

    Pooja Sisodia
    This code connects to a database, queries for course IDs starting with "IC", adds them to a dropdown list, and catches several types of exceptions, displaying error messages for each.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as DOC, PDF, TXT or read online from Scribd
    Download as doc, pdf, or txt
    You are on page 1of 2

    //FOR UNIQUE C_ID IN DROPDOWN-LIST SqlConnection cn = new SqlConnection(); cn.ConnectionString = ConfigurationManager.ConnectionStrings["project"].ConnectionString.ToString(); cn.Open(); SqlCommand cmd = new SqlCommand(); cmd.

    Connection = cn; cmd.CommandText = "select C_ID from dbo.tab_courseSchedule group by C_ID HAVING C_ID LIKE 'IC%'"; SqlDataReader dread = cmd.ExecuteReader(); while (dread.Read()) { ddl_Cno.Items.Add(dread["C_ID"].ToString()); } dread.Close();

    #region catch //foreign key exception catch (InvalidOperationException ) { ShowAlertMessage("Invalid Operation Performed!!"); } //primary Key exception catch(DuplicateNameException) { ShowAlertMessage("Record Already Exists !!"); } catch(ConstraintException) { ShowAlertMessage("Constraint Violated !!"); } catch (System.Web.HttpException)

    ShowAlertMessage("A Web Exception occurred!!"); } catch (IndexOutOfRangeException) { ShowAlertMessage("Index Out Of Bounds Error!!"); } catch (FormatException) { ShowAlertMessage("Incorrect Data Format!!"); } catch (OverflowException) { ShowAlertMessage("Length of Data Exceeds!!"); } catch (NullReferenceException) { ShowAlertMessage("Null Reference Error !!"); } catch (StackOverflowException) { ShowAlertMessage("StackOverflow Error!!"); } catch(ArgumentException) { ShowAlertMessage("Illegal Argument Error!!"); } catch(DataException) { ShowAlertMessage("Data Access Error!!"); } catch (Exception) { ShowAlertMessage("Error!!"); } #endregion finally { cn.Close(); } }

    You might also like