I am encountring a strange problem.
Consider d following code :
NOTE: MY CONNECTION IS ESTABLISHED SUCCESSFULLY
1 .
Dim dtattendance As New DataTable
dbadapterattend = New OleDbDataAdapter("select tbladmission.[admid],tbladmission.[vName],tblattendance.[status] from tbladmission INNER [ dgattendance.DataSource = dtattendance
I DO GET DESIRED OUTPUT AFTER EXECUTION OF THIS CODE.
However if i REPLACE the code by using Data Set instead of Data Table say for eg..
i write :
2.
Dim dsattendance As New Dataset
dbadapterattend = New OleDbDataAdapter("select tbladmission.[admid],tbladmission.[vName],tblattendance.[status] from tbladmission INNER JOIN tblattendance ON tbladmission.[admid]=tblattendance.[admid]", connectionstring)
dbadapterattend = New OleDbDataAdapter("Select * from tblattendance", connectionstring)
dbadapterattend.Fill(dsattendance)
dgattendance.DataSource = dsattendance
AFTER I RUN AND CLICK BUTTON MY DATAGRID IS NOT POPULATED !! WHY IS THIS PROBLEM ??? PLZ HELP ME OUT....
2) I WANT TO UPDATE MY DATABASE THRU DATAGRID WHICH WILL BE DISPLAYED BY ABOVE CODE FOR THAT IS DATA SET PROPERTY ESSENTIAL OR IT CAN BE DONE WITH DATATABLE ALSO LIKE IN CODE 1 ABOVE ??? I AM CONFUSED PLZ HELP ME OUT.....
AWATING QUICK REPLY AS ALWAYS
CYA
ROHAN