Here is my code:
Can any one solve my problem?
Code:
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using HomeDataLayer;
using System.Windows.Forms;
public partial class Reminders : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
txtRemindDate .Text = System.DateTime.Now.Date.ToShortDateString();
FillGrid();
}
}
public void FillGrid()
{
DataTable dt = HomeManagement.SelectReminders();
if (dt != null)
if (dt.Rows.Count > 0)
{
RemindersGrid.DataSource = dt;
RemindersGrid.DataBind();
for (int i = 0; i < RemindersGrid.Rows.Count; i++)
{
if (RemindersGrid.Rows[i].Cells[4].Text == Convert.ToString(System.DateTime.Now.Date))
{
RemindersGrid.Rows[i].BackColor = System.Drawing.Color.LightYellow;
//string msg = RemindersGrid.Rows[i].Cells[1].Text;
//msg += "<br>" + RemindersGrid.Rows[i].Cells[4].Text;
//System.Windows.Forms.MessageBox.Show(msg);
}
}
}
else
{
RemindersGrid.DataSource = null;
RemindersGrid.DataBind();
}
}
protected void submit_Click(object sender, ImageClickEventArgs e)
{
try
{
int i = HomeManagement.InsertReminder(txtIssue.Text, txtName.Text, Convert.ToDateTime(txtRemindDate.Text), System.DateTime.Now.Date );
if (i > 0)
{
System.Windows.Forms.MessageBox.Show("Succcessfully Inserted");
txtRemindDate .Text = System.DateTime.Now.Date.ToShortDateString();
txtIssue.Text = txtName.Text = "";
}
}
catch (Exception err)
{
System.Windows.Forms.MessageBox.Show(err.ToString ());
}
}
protected void RemindersGrid_RowEditing(object sender, GridViewEditEventArgs e)
{
RemindersGrid.EditIndex = e.NewEditIndex;
FillGrid();
}
protected void RemindersGrid_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
bool flag;
if (RemindersGrid.DataSource == null)
flag = false;
else
{
}
try
{
RemindersGrid.EditIndex = e.RowIndex;
int ID = e.RowIndex;
string name = RemindersGrid.Rows[e.RowIndex ].Cells[2].Text ;
int i = HomeManagement.UpdateReminder(RemindersGrid.Rows[e.RowIndex].Cells[5].Text, RemindersGrid.Rows[ID].Cells[2].Text, Convert.ToDateTime(RemindersGrid.Rows[ID].Cells[4].Text), Convert.ToDateTime(RemindersGrid.Rows[ID].Cells[3].Text), int.Parse(RemindersGrid.Rows[ID ].Cells[1].Text));
if (i > 0)
MessageBox.Show("Update Successfully");
}
catch (Exception err)
{
MessageBox.Show(err.ToString());
}
}
protected void RemindersGrid_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
int index = e.RowIndex;
FillGrid();
RemindersGrid.EditIndex = e.RowIndex;
int i = HomeManagement.DeleteReminders(int.Parse(RemindersGrid.Rows[index].Cells[1].Text));
if (i > 0)
MessageBox.Show("Deleted Successfully");
}
protected void RemindersGrid_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
{
// FillGrid();
RemindersGrid.EditIndex = -1;
}
}
Comment