Well, I'll look into my crystal ball and tell you what
I've experienced according to your lack of description of
your problem and error codes:
1st make 1 recordset per databinding. I'll assume you
are using MS-SQL (I recognise the practice db). I
believe you will need to do this to keep track of the
data pointers for current record.
I've not seen a good implementation of batch queries with
bindings, if it can be done I cannot say, but revert back
to the standard of 1 query--1 resultset--1 data control.
if you need an articulated subquery or join then that is
another problem, you'll need to restucture the sql
appropriately to provide you with the recordset you
desire.
-----Original Message-----
Hi!
I see my self as new to programming in a c# environment, and insecure in SQLqueries. I appreciate any help.
I'm building a windowsapplication with among others datagrids anddatabindings. Uptil now it has been an increasing development :-)
I thought that batch queries was the answer to my problems. But I'm havingtrouble making my query generic for showing the result in a datagrid togetherwith a current row.
example:
select count (orderID) From Orders Where OrderDate < '1.1.2001';select * from orders
group by CostumerID
.