Combobox,datetimepicker,search button and datagridview

Question

In visual studio with C# code, I have combobox,datetimepicker(start date), datetimepicker(end date), datagridview and search button. I want to select item from combobox with start date and end date then pressing search button data will be shown in datagridview. Is it possible? Then sample code or example link please.

Ramesh Palanivel · Accepted Answer

Hi Shovan,     Yes Its possible..  Here the code was just manually write  myself.. syntax error may occur.. just try and let me know.. Feel free post your queries.....
public  button1_click()  // Button click event    {      string  ProductName=combobox1.selectedValue;   string  FromDate=datetimepicker1.Text.toString().ToshortDateString();   string  ToDate=datetimepicker2.Text.toString().ToshortDateString();    Displaygridview(ProductName,FromDate,ToDate)   }            public   void  Displaygridview( string  ProductName, string  FromDate, string  ToDate)   {   if ((ProductName!= ""  && ProductName!= null ) && (ProductName!= ""  && ProductName!= null ) && (ProductName!= ""  && ProductName!= null ))   {   con.open();   Dataset ds= new  Dataset();   SqlDataAdapter sdr= new  SqlDataAdapter( "select * from ProductSellingDetails where ProductName='" +ProductName+ "' and StartDate='" +FromDate+ "' between EndDate='" +ToDate+ "'" ,con);   sdr.Fill(ds);   datagridview1.DataSource=ds.Tables[0];   con.close();   }   }

Shovan Saha · Answer

Hi Mr. Ramesh, Before using your suggestion, I have faced another problem (An error occurred while signing: SignTool.exe was not found at path C:\ProgramFiles\Microsoft SDKs\Windows\v7.0A\bin\signtool.exe.). Would you like to help me at this regard?