How to fill datagrid when complex join query is available?

Question

I have problem to fill grid in c#

OleDbCommand cmd = new OleDbCommand("SELECT data.acno, data.BillNo AS, data.Name,
Sum([Price]*[qty]) AS ટોટલ FROM data INNER JOIN agro ON data.BillNo = agro.BillNo 
GROUP BY data.acno, data.BillNo, data.Name, data.db, data.Date HAVING 
(((data.db)='true') AND ((data.Date) = '" + coGuj(drpDate.Text) + "'))", con);

DataSet ds = new DataSet();
OleDbDataAdapter da = new OleDbDataAdapter(cmd);
da.Fill(ds);
viewgrid_credit.DataSource = ds.Tables[0];

This code write to fill grid but no arise any error not fill grid only display heading of grid but not return require output.

Query is 100% correct this query run in access successfully and also return result.

You may also want to read about SQL injection: http://stackoverflow.com/questions/332365/how-does-the-sql-injection-from-the-bobby-tables-xkcd-comic-work — Paddy, Dec 20 '13 at 11:28
@ Grant Winney : i put break point but at debug i am only watch heading — Hiren Raiyani, Dec 20 '13 at 11:34

score 0 · Answer 1 · answered Dec 20 '13 at 11:36

1) Try debugging it and set a break-point at :

da.fill(ds)

to see if any data is returned.

2) If that does not work, I will suggest breaking the query down and using a few simple queries first.

    var cmd = new OleDbCommand("SELECT data.acno, data.BillNo, data.Name,
                                Sum([Price]*[qty]) AS ટોટલ 
                                FROM data", con);

    var ds = new DataSet();
    var da = new OleDbDataAdapter(cmd);
    da.Fill(ds);
    viewgrid_credit.DataSource = ds.Tables[0];

See if this works and then append your extra query.

Simple query properly work but this query not give output, how can i do more any other way to execute query? — Hiren Raiyani, Dec 20 '13 at 11:41

score 0 · Answer 2 · answered Dec 21 '13 at 02:45

0

There is only single mistake (but that not mistake becasue in access that is return result properly). When we fire query directly in access then '*' is allowed to pattern matching but in C# that compulsory to use '%' require.

answered Dec 21 '13 at 02:45

Hiren Raiyani

754
2
12
28

How to fill datagrid when complex join query is available?

2 Answers2