One C# Data Grid View displaying on multiple queries input

[aqeel27]

I have created a generic method which would take the _query string, obj of datagridview, tablename, obj of dataset_ as shown below

private void data(string dgvq, DataGridView dgvw, string sTableNm, DataSet dgset)
        {
            createconn();
            dgset.Clear();
            dAdapter = objADOUI.GetDataAdapter(dgvq, myConn);
            dAdapter.Fill(dgset);
            dgvw.DataSource = dgset.Tables[0].DefaultView;
            this.myConn.Close();
        }
 

I am calling this method on different buttons as the are clicked, by passing different parameters. shown below is an example of how its being called.

        DataSet dset1 = objADOUI.GetDataSet();
        data(Qdgv, dgvDpnl, "TStudent", dset1);

Now, the problem is, Its displaying for once, I mean- When `button1` is clicked its displaying the appropriate results.

But,when `button2` is clicked which has parameters as followed,

        DataSet dset2 = objADOUI.GetDataSet();
        data(Qdgv, dgvDpnl, "TStudent", dset2);

its creating an exception: <br/>
`"At most one record can be returned by this subquery"` at `data(definition)>dAdapter.Fill(dgset);`

**Note:**
Let me tell u the problem is not with the query, since `button1` is also passing the query which has _sub-queries_ too.

I am aware that the problem is about `unloading` the resources in `datagridview`, `dataset` and `reloading` it.
But, I have tried a lot and couldn't find the solution.

Any help would be appreciated.

[Frinavale]

Your C# code looks fine so I did a bit of research on the web and it looks like this exception is thrown the SQL syntax is not accepted by the database.

-Frinny

[Rabbit]

Looks that way to me too. The issue is the query. It's not that you're using subqueries that's causing the issue. It's that the subquery is returning more than one row. Depending on how it's being used, subqueries can be limited to only one row.