protected void lnkbtnExcel_Click(object sender, EventArgs e) { string strMsg = string.Empty; DateTime? DateOn; DataTable dt = new DataTable(); WhatsNewDAL obj1 = new WhatsNewDAL(); DateOn = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDate.Text)); var selectdata = obj1.SelectAll(DateOn, Convert.ToInt64(ddlForm.SelectedValue)); obj1 = null; if (selectdata != null && selectdata.Count > 0) { dt.Columns.Add("SrNo", typeof(string)); dt.Columns.Add("Date", typeof(string)); dt.Columns.Add("FormName", typeof(string)); dt.Columns.Add("Details", typeof(string)); for (int i = 0; i < selectdata.Count; i++) { DataRow dr = dt.NewRow(); dr["SrNo"] = Convert.ToString(i + 1); dr["Date"] = Convert.ToString(DataBinder.Eval(selectdata[i], "Date")); dr["FormName"] = Convert.ToString(DataBinder.Eval(selectdata[i], "FormName")); dr["Details"] = Convert.ToString(DataBinder.Eval(selectdata[i], "Details")); dt.Rows.Add(dr); } } Export(dt); }
private void BindFormName() { WhatsNewDAL obj = new WhatsNewDAL(); var FrmName = obj.BindFormName(); ddlForm.DataSource = FrmName; ddlForm.DataTextField = "FormName"; ddlForm.DataValueField = "FormIdno"; ddlForm.DataBind(); obj = null; ddlForm.Items.Insert(0, new ListItem("--Select--", "0")); }
protected void lnkbtnSave_Click(object sender, EventArgs e) { string strMsg = string.Empty; DateTime? DateOn; WhatsNewDAL obj1 = new WhatsNewDAL(); DateOn = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDate.Text)); Int64 intWhatsIdno = 0; intWhatsIdno = obj1.Insert(DateOn, Convert.ToInt64(ddlForm.SelectedValue), txtDetails.Text); if (intWhatsIdno > 0) { ShowMessage("Record saved successfully."); this.ClearControls(); } }