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