public void Grid_Bind() { GridUserCred.DataSource = null; GridUserCred.DataBind(); SqlDataAdapter sda; DataTable dt = new DataTable(); sda = new SqlDataAdapter(query, con); sda.Fill(dt); if (dt.Rows.Count > 0) { GridUserCred.DataSource = dt; GridUserCred.DataBind(); ScriptManager.RegisterStartupScript(Page, this.GetType(), "Key", "<script>MakeStaticHeader('" + GridUserCred.ClientID + "', 750, 100 , 100 ,false); </script>", false); } }
protected void btnSeacrchDate_Click(object sender, EventArgs e) { DateTime dos = DateTime.Parse(txtDate.Text.Trim()); string searchdate = dos.ToString("dd/MM/yyyy"); GridUserCred.DataSource = null; GridUserCred.DataBind(); SqlDataAdapter sda; DataTable dt = new DataTable(); query = query + " where convert(date,[loginDate],105)=convert(date,'" + searchdate + "',105)"; sda = new SqlDataAdapter(query, con); sda.Fill(dt); if (dt.Rows.Count > 0) { GridUserCred.DataSource = dt; GridUserCred.DataBind(); ScriptManager.RegisterStartupScript(Page, this.GetType(), "Key", "<script>MakeStaticHeader('" + GridUserCred.ClientID + "', 750, 100 , 100 ,false); </script>", false); } }