public void rebind()
{
con = new SqlConnection(cs);
cmd.CommandText = "select ID, Title,FirstName,LastName, CONVERT(varchar, Birthday,101) As Birthday ,Email1,Email2,Land_line,mobile,Address1,Address2 from MainInfo";
da = new SqlDataAdapter(cmd);
cmd.Connection = con;
da.Fill(ds);
con.Open();
cmd.ExecuteNonQuery();
GridAllRecord.DataSource = ds;
GridAllRecord.DataBind();
}
public void rebind()
{
con = new SqlConnection(cs);
cmd.CommandText = "select ID,FirstName,LastName, CONVERT(varchar, Birthday,101) As Birthday from MainInfo where DAY(Birthday) = DAY(GETDATE()) and MONTH(Birthday) = MONTH(GETDATE()) or DAY(Birthday) = DAY(GETDATE()+1) and MONTH(Birthday) = MONTH(GETDATE()) or DAY(Birthday) = DAY(GETDATE()+2) and MONTH(Birthday) = MONTH(GETDATE()) or DAY(Birthday) = DAY(GETDATE()+3) and MONTH(Birthday) = MONTH(GETDATE()) or DAY(Birthday) = DAY(GETDATE()+4) and MONTH(Birthday) = MONTH(GETDATE()) or DAY(Birthday) = DAY(GETDATE()+5) and MONTH(Birthday) = MONTH(GETDATE()) ;";
da = new SqlDataAdapter(cmd);
cmd.Connection = con;
da.Fill(ds);
con.Open();
cmd.ExecuteNonQuery();
GridAllRecord.DataSource = ds;
GridAllRecord.DataBind();
}
public void showSearchRecord()
{
con = new SqlConnection(cs);
cmd.CommandText = commandSearch;
cmd.Connection = con;
da = new SqlDataAdapter(cmd);
da.Fill(ds);
con.Open();
cmd.ExecuteNonQuery();
if (ds.Tables[0].Rows.Count > 0)
{
lblError.Text = "";
GridAllRecord.DataSource = ds;
GridAllRecord.DataBind();
}
else
{
lblError.Text = "Entry not found.";
GridAllRecord.DataSource = ds;
GridAllRecord.DataBind();
}
}
