예제 #1
0
 public void GetRecords()
 {
     try
     {
         dal = new DAL();
         DataSet ds;
         ds = new DataSet();
         ds = dal.GetSetSUBJECTDETAILS(Action: "GET_DATA", INVID: drp_InvID.SelectedValue);
         SUBJDETAILS.DataSource = ds;
         SUBJDETAILS.DataBind();
     }
     catch (Exception ex)
     {
         lblErrorMsg.Text = ex.Message.ToString();
     }
 }
예제 #2
0
        protected void bntAdd_Click(object sender, EventArgs e)
        {
            try
            {
                //Table Structure
                DataRow   drCurrentRow = null;
                DataTable dtCurrentTable;
                int       rowIndex = 0;
                int       i;
                dtCurrentTable = new DataTable();
                dtCurrentTable.Columns.Add(new DataColumn("STUDYID", typeof(string)));
                dtCurrentTable.Columns.Add(new DataColumn("SUBJID", typeof(string)));
                dtCurrentTable.Columns.Add(new DataColumn("UPDATE_FLAG", typeof(string)));

                if (SUBJDETAILS.Rows.Count > 0)
                {
                    for (i = 0; i < SUBJDETAILS.Rows.Count; i++)
                    {
                        drCurrentRow = dtCurrentTable.NewRow();

                        drCurrentRow["STUDYID"]     = ((TextBox)SUBJDETAILS.Rows[rowIndex].FindControl("STUDYID")).Text;
                        drCurrentRow["SUBJID"]      = ((TextBox)SUBJDETAILS.Rows[rowIndex].FindControl("SUBJID")).Text;
                        drCurrentRow["UPDATE_FLAG"] = ((TextBox)SUBJDETAILS.Rows[rowIndex].FindControl("UPDATE_FLAG")).Text;
                        dtCurrentTable.Rows.Add(drCurrentRow);
                        rowIndex++;
                    }

                    //Add Empty Row
                    drCurrentRow = dtCurrentTable.NewRow();
                    drCurrentRow = dtCurrentTable.NewRow();

                    drCurrentRow["STUDYID"]     = "";
                    drCurrentRow["SUBJID"]      = "";
                    drCurrentRow["UPDATE_FLAG"] = "0";
                    dtCurrentTable.Rows.Add(drCurrentRow);
                }
                SUBJDETAILS.DataSource = dtCurrentTable;
                SUBJDETAILS.DataBind();
            }
            catch (Exception ex)
            {
                lblErrorMsg.Text = ex.Message.ToString();
            }
        }