protected void AddRow(object sender, EventArgs e) { UpdatepagedData(); DataTable DtPagedData = ((DataTable)ViewState["PagedData"]); DataRow Dr = DtPagedData.NewRow(); Dr["TId"] = 0; Dr["TEDATE"] = DateTime.Now.Date; Dr["TResourceId"] = resourceid; Dr["TECreatedon"] = DateTime.Now.Date; Dr["TEfforts"] = 0; Dr["TicketNumber"] = " "; Dr["TikcetCreatedOn"] = DateTime.Now.Date; Dr["TicketDescription"] = " "; Dr["TicketTypeId"] = 0; Dr["ApplicationId"] = 0; Dr["ApplicationTypeId"] = 0; Dr["VendorId"] = 0; Dr["ClassificationId"] = 0; Dr["TicketStatusId"] = 0; Dr["Mode"] = "I"; //Dr["Mode"] = "U"; DtPagedData.Rows.Add(Dr); RptAddefforts.DataSource = DtPagedData; RptAddefforts.DataBind(); }
private void BindCurrentdayData() { if (Request.QueryString["date"] != null) { DateTime DtDate = DateTime.ParseExact(Request.QueryString["date"], "dd/MM/yyyy", null); DataTable DtSelectmonthsefforts = new DataTable(); DtSelectmonthsefforts.TableName = "TblEfforts"; IDataReader Dr; SqlConnection con = new SqlConnection(); try { con.ConnectionString = ConfigurationManager.ConnectionStrings["TMS"].ConnectionString; con.Open(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.Connection = con; cmd.CommandText = "prc_getcurrentdayefforts"; cmd.Parameters.AddWithValue("@currentdate", DtDate); cmd.Parameters.AddWithValue("@resourceid", resourceid); Dr = cmd.ExecuteReader(); DtSelectmonthsefforts.Load(Dr); con.Close(); ViewState["PagedData"] = DtSelectmonthsefforts; if (DtSelectmonthsefforts != null && DtSelectmonthsefforts.Rows.Count > 0) { LblPagemode.Text = "U"; } else { LblPagemode.Text = "I"; } RptAddefforts.DataSource = DtSelectmonthsefforts; RptAddefforts.DataBind(); } catch (Exception M) { throw; } finally { if (con.State == ConnectionState.Open) { con.Close(); } } } }