private void button1_Click(object sender, EventArgs e)
{
this.Close();
DashBoard frmDashBoard = new DashBoard();
frmDashBoard.Show();
}
protected void cbCompleted_Changed(object sender, EventArgs e)
{
try
{
CheckBox chk = (CheckBox)sender;
string name = chk.Name;
string query;
string id = name.Substring(name.LastIndexOf("_") + 1);
if (MessageBox.Show("Are you sure to Update:", "message", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
query = "Update tblNote set Completed=" + Convert.ToInt16(chk.Checked) + " Where note_id=" + id;
DBConnection db = new DBConnection();
db.executyQuery(query);
MessageBox.Show("Updated successfully");
}
else
{
DashBoard frmDashBoard = new DashBoard();
frmDashBoard.Show();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void button1_Click(object sender, EventArgs e)
{
try
{
string query = "select * from tblUser where username='******'and password='******'";
DBConnection db = new DBConnection();
DataTable dt = db.GetData(query);
if (dt.Rows.Count > 0)
{
DashBoard frmDashBoard = new DashBoard();
frmDashBoard.user_id = Convert.ToInt32(dt.Rows[0]["user_id"]);
frmDashBoard.Show();
}
else
{
MessageBox.Show("username and password not Exists");
}
txtpassword.Text = string.Empty;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}