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(); } }