To fetch data in Datagridview Control

Question

i have a form with datetimepicker,button,datagridview. in SQL i have a table with feeid,feeno,classid,feedate,total named fee.

when we click the button, I want to select all the data from sql according to Selected date
(datetimepicker) and it will displayed in datagridview.

Riddhi Valecha · Answer

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.

sheetal · Answer

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

DevMaster India · Answer

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.

Mayur Gujrathi · Answer

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) + "'";

Karthikeyan Anbarasan · Answer

Do u want to save the same time picked from the grid view? or what exactly is the issue u face?

Shyja Abraham · Answer

problem is, when we select the date from datetimepicker,the date is ok,but the time is present time.but in database contains the differnt time .how we resolve it?

Mayur Gujrathi · Answer

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

Shyja Abraham · Answer

i use this code. but this is not working. private void button1_Click(object sender, EventArgs e) { cmd.CommandText = "select * from fee where feedate='" + DateTime.Parse(dateTimePicker1.Value.ToString()) + "'"; da.SelectCommand = cmd; da.Fill(ds, "name"); DataTable dt1 = ds.Tables["name"]; //dt.Clear(); displaygrid.DataSource = dt1; } ;

Mayur Gujrathi · Answer

do coding on DateTimePicker value changed event it has value property private void DateTimePicker1_ValueChanged(Object sender, EventArgs e) { MessageBox.Show( "You are in the DateTimePicker.ValueChanged event." ); }

Shyja Abraham · Answer

sorry this is not help me.i want a query to retrieve data from fee table according to selected date.

Sam Hobbs · Answer

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.

To fetch data in Datagridview Control

Answers (11)