jshanoo
asked on
DataGrid; data from two tables
Hi ,
I have datagrid
and data is shown from table A Anb B
table A contains client id and B his cheque details
cleint id is a foriegn key in table B.
in datagrid i want to show the cheque details,
and i want edit and delete all things from teh datagrid itself.
/// SQL Stmt
rs1.CursorLocation = adUseClient
rs1.Open "SELECT A.ContractID, B.ChequeNo, B.Bankname, B.chqamt, B.status, B.chkdate FROM Contract AS A INNER JOIN ChequeDetails AS B ON A.ContractID = B.ContractID", conn1, adOpenDynamic, adLockOptimistic
Set dgdCheque.DataSource = rs1
dgdCheque.Refresh
Can u please help me in this
I have datagrid
and data is shown from table A Anb B
table A contains client id and B his cheque details
cleint id is a foriegn key in table B.
in datagrid i want to show the cheque details,
and i want edit and delete all things from teh datagrid itself.
/// SQL Stmt
rs1.CursorLocation = adUseClient
rs1.Open "SELECT A.ContractID, B.ChequeNo, B.Bankname, B.chqamt, B.status, B.chkdate FROM Contract AS A INNER JOIN ChequeDetails AS B ON A.ContractID = B.ContractID", conn1, adOpenDynamic, adLockOptimistic
Set dgdCheque.DataSource = rs1
dgdCheque.Refresh
Can u please help me in this
ASKER CERTIFIED SOLUTION
![Avatar of Guy Hengel [angelIII / a3]](https://filedb.experts-exchange.com/files/public/2013/11/25/ddbe0ea6-aa6e-4279-b781-57b735dd3ea0.jpeg){kind=small}
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Moderator, my recommended disposition is:
Accept angelIII's comment(s) as an answer.
DanRollins -- EE database cleanup volunteer
Accept angelIII's comment(s) as an answer.
DanRollins -- EE database cleanup volunteer
This old question needs to be finalized -- accept an answer, split points, or get a refund. For information on your options, please click here-> http:/help/closing.jsp#1
Experts: Post your closing recommendations! Who deserves points here?