To fetch data in Datagridview Control

Hi...

Try this code. It works-

DateTime dt;
SQLConnection con;
SQLCommand cmd;
SQLDataAdapter;
Datatable table;

private void DateTimePicker1_ValueChanged(Object sender, EventArgs e)
{
dt = DateTimePicker1.Selecteddate.value;
}
private void button1_click(object sender, EventArgs e)
{
try
{

 con = new SQLConnection(@"connection string");
 con.open();
 string s = "select * from tablename where Date='"+dt+"'";
 cmd = new SQLCommand(con, s);
 adp = new SQLDataAdapter();
 adp.SelectCommand = cmd;
 table = new DataTable();
 adp.Fill(table);
 datagridview1.dataSource = table;
 datagridview1.bind();
 }
catch(Exception err){err.Message.ToString();}
finally
{
if(con.State == ConnectionState.open)
{
 con.Close();
}
}

}
------------

If you still have issues, and do not mind in sharing the project, do share it.

Hope this helps.

Hi

Please check the datatype of your feedate in sql data table. Change it to varchar if it is datetime or smalldatetime.

on button click event u can write

sql command
comm=new sqlcommand("ur query where feedate='"+dtp.value+"' ");
fill the adapter 
set datasource property of grid.

Thanks,
Sheetal

Hello Shyja,
The problem u are facing is associated with TimeStamp with datetime type of columns, so just remove the time from both side (Database column & variable both) & compare the dates. Whats the issue in this?

The date from front end must be sent in the format you choose in the datetime picker control. (DD/MM or MM/DD)

Example:
SELECT * FROM
WHERE Convert(varchar(20), , 101) = '01/01/2011'

Note: The '101' (also 103) can be used to format the datetime fields into 'DD/MM/YYYY' or 'MM/DD/YYYY' formats.

Ok problem it is not matching because your front end value is different tan database value so you are not getting error this time but not getting data also
so you need to convert your datetime picker value into string and get into strin variable, you can get it easily from net and then do

cmd.CommandText = "select * from fee where feedate='" + DateTime.Parse(variable name) + "'";

what problem you are facing? are you getting any error? if yes then paste that error here and if not then write stored procedure having feedate as string data type
and then convert date to string

Start by looking at the articles in this web site. There are many articles that will help you. My article Database Table Update in a DataGridView without Writing Code is one of very many articles that will help you.