Loading

select querry to display on gridview

syed ziya

Hiii frnds,

i wrote below code to display in gridview as per date, but it is giving me error.

code:

string s = "select Sno,[Flight_no],[Dept_time],[Arr_time],Route,[dest_1],dest2,dest3,dest4,load,[Actual_cap],water,juice,initial from days where date=" +lbldatee.Text ;

OleDbCommand cmd = new OleDbCommand(s, con);

using

{

adapter.Fill(ds);

dataGridView1.DataSource = ds.Tables[0];

}

(OleDbDataAdapter adapter = new OleDbDataAdapter(s, con))DataSet ds = new DataSet();

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jaganathan Bantheswaran13y ago
What is the error you are getting?
durgaprasad rangula13y ago
Hi,

You should convert string (lbldatee.Text) to date format.If it is date formatted string then it should be in single quotes.

ex : string s = "select Sno,[Flight_no],[Dept_time],[Arr_time],Route,[dest_1],dest2,dest3,dest4,load,[Actual_cap],water,juice,initial from days where date='" +lbldatee.Text + "';