please help! this is urgent> how to retrieve data to my tabpage without using data form wizard?
-
hi im new to database and still figuring out how to use them... this is very urgent.. i want to retrieve a particular user's data from MS Access to my tab page of textboxes/radio buttons/combo boxes.. i want to allocate specific data in specific textboxes/radio buttons/combo boxes without using data form wizard.. i did databiding of controls to my table columns, but it's not showing when i run my app.. what should i do? i appreciate it if you could provide me with specific details due to my time constrain.. thank you!
-
hi im new to database and still figuring out how to use them... this is very urgent.. i want to retrieve a particular user's data from MS Access to my tab page of textboxes/radio buttons/combo boxes.. i want to allocate specific data in specific textboxes/radio buttons/combo boxes without using data form wizard.. i did databiding of controls to my table columns, but it's not showing when i run my app.. what should i do? i appreciate it if you could provide me with specific details due to my time constrain.. thank you!
nidhelp wrote: i did databiding of controls to my table columns, but it's not showing when i run my app.. How do you retrived the data and did data binding? MCAD
-
nidhelp wrote: i did databiding of controls to my table columns, but it's not showing when i run my app.. How do you retrived the data and did data binding? MCAD
what i did was only go to my textboxes/radio btns/combo boxes' properties>(databinding)>(advanced)>text>select in treeview mydataset>fieldname... in data adapter preview i can see all the users' data displayed... how do i only show a chosen user's data in textboxes/radio btns/combo boxes when i run the app.. i've a textbox for user to key in ID No. and a ok button.. can my ok button represent a load button to load the data of user whose ID no. was entered in text box? how do i go on exactly? i've read articles already.. i learn when i actually do it, reading helps to clear some of my doubts but hands-on helps me learn faster and easier... please give me some real guidance if you are free, ok?? i suppose i still have a lot to do to achieve what i want... im rushing against time!! please help... Thanks!!
-
what i did was only go to my textboxes/radio btns/combo boxes' properties>(databinding)>(advanced)>text>select in treeview mydataset>fieldname... in data adapter preview i can see all the users' data displayed... how do i only show a chosen user's data in textboxes/radio btns/combo boxes when i run the app.. i've a textbox for user to key in ID No. and a ok button.. can my ok button represent a load button to load the data of user whose ID no. was entered in text box? how do i go on exactly? i've read articles already.. i learn when i actually do it, reading helps to clear some of my doubts but hands-on helps me learn faster and easier... please give me some real guidance if you are free, ok?? i suppose i still have a lot to do to achieve what i want... im rushing against time!! please help... Thanks!!
I hope i understood what you need correctly You want to display the data for the user which have Specific ID Is this OK? if yes if you got all the data of customer table for example into
DataSetto filter the data by customer IDDatasetDefaultViewhaveFilterProperty which you can set And it will be filter the data some thing like thatDataSet.Customers.DefaultView.RowFilter="CustomerID='XYZ'" ;This will display onley the data of customer who have customerID='xyz' So modify this code to work in your case The other thing get the data you need only dont return all table and you really need few records to do this dont use some thing like
SELECT CustomeID,CustomerName,.. FROM CustomersYou can get the data you only need by addWhere ClauselikeSELECT CustomeID,CustomerName,.. FROM Customers Where CustomerID='xyz'MCAD -
I hope i understood what you need correctly You want to display the data for the user which have Specific ID Is this OK? if yes if you got all the data of customer table for example into
DataSetto filter the data by customer IDDatasetDefaultViewhaveFilterProperty which you can set And it will be filter the data some thing like thatDataSet.Customers.DefaultView.RowFilter="CustomerID='XYZ'" ;This will display onley the data of customer who have customerID='xyz' So modify this code to work in your case The other thing get the data you need only dont return all table and you really need few records to do this dont use some thing like
SELECT CustomeID,CustomerName,.. FROM CustomersYou can get the data you only need by addWhere ClauselikeSELECT CustomeID,CustomerName,.. FROM Customers Where CustomerID='xyz'MCADhi you see, when i use data form wizard, the form just pop-up across my screen as i used the show form method.. my most important need now is to be able to place my form that i had generated from data form wizard INTO a tab page... i tried to copy and paste the form controls over to a tab page, the result was that the form could not load.. i want the form to be placed in a tab page which i've already created and is working well.. PLEASE help me... thanks