private void bindRadio()
{
try
{
cmd = new SqlCommand("select ID from InstitutionReg where Name='" + ddlFinalOpn.SelectedValue.ToString() + "'", con);
string Insid = Convert.ToString(cmd.ExecuteScalar());
cmd.ExecuteNonQuery();
cmd = new SqlCommand("update Project set Status='ProformaAApproved',Institution='" + ddlFinalOpn.SelectedValue.ToString() + "', InstitutionID='" + Insid + "',Remark='" + txtSynRemarks.Text.ToString() + "', ProjectNo='" + txtProjectNo.Text.ToString() + "' where EntryStatus='Running' and SID='" + GridAppPerfmA.SelectedRow.Cells[2].Text.ToString() + "'", con);
cmd.ExecuteNonQuery();
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "success", "alert('Data Approved Successfully!')", true);
bindGrid(); pnlData.Visible = false; GridAppPerfmA.Focus();
}
catch (NullReferenceException ex) { lblApprvExcep.Text = "Invalid!"; }
}
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 = "";
}
