Example #1
0
    private void okk(string strid)
    {
        lblExceptionOK.Text = "";
        adp = new SqlDataAdapter("select DiaryA,SID,Course,Part,SynopsisDate,Status from Project where sid='" + strid + "' and Status='ProformaASubmitted' and EntryStatus='Running'", con);
        DataTable dt = new DataTable();

        adp.Fill(dt);
        GridAppPerfmA.DataSource = dt;
        GridAppPerfmA.DataBind();
        GridAppPerfmA.Focus();
        if (GridAppPerfmA.Rows.Count == 0)
        {
            txtSID.Text = ""; lblExceptionOK.Text = "Please Enter Correct Membership ID!"; txtSID.Focus();
        }
    }
Example #2
0
 private void bindGrid()
 {
     adp = new SqlDataAdapter("select DiaryA,SID,Course,Part,SynopsisDate,Session,Status from Project where Status='ProformaASubmitted' and EntryStatus='Running'", con);
     DataTable dt = new DataTable(); adp.Fill(dt); GridAppPerfmA.DataSource = dt; GridAppPerfmA.DataBind();
 }
Example #3
0
 protected void btnView_Click(object sender, EventArgs e)
 {
     adp = new SqlDataAdapter("Select IMID,SID,Course,Part,DiaryA,Option1,Option2,Option3 from Project where IMID='" + txtIMID.Text.ToString() + "' and Status='ProformaASubmitted' and EntryStatus='Running'", con);
     DataTable dt = new DataTable(); adp.Fill(dt); GridAppPerfmA.DataSource = dt; GridAppPerfmA.Columns[0].Visible = false; GridAppPerfmA.DataBind(); lblNotIM.Text = "";
 }