Hai Techie
When i selects the date from dropdown list it will display in two text boxes.Based on two textboxes values grid view should display the filtered data .But the gridview does not visible
Here is the code
SqlConnection objcon = new SqlConnection("Data Source=.;Initial Catalog=Iwens_Database;User ID=sa;Password=123;Integrated Security=SSPI;");
objcon.Open();
try
{
selectionquery = "SELECT E_id, E_Name, E_Address, E_Contact_No, E_Email, DOEn, E_noi, E_coursename, E_year, E_companyname, E_others, E_design, E_Selected, E_Followup FROM dbo.Enquiry_table where DOEn between'" + FromTextBx.Text + "' AND '" +ToTextBx.Text + "'";
SqlDataAdapter objsda = new SqlDataAdapter(selectionquery,objcon );
DataSet objds = new DataSet();
objsda.Fill(objds, "Enquiry_table");
BetweenGridView.DataBind();
objcon.Close();
}
catch (Exception ex)
{
Response.Write(ex.Message);
}