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(); } }
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(); }
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 = ""; }