By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,335 Members | 2,258 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,335 IT Pros & Developers. It's quick & easy.

working with datagrid control

P: 1
form is created which contains textboxes , labels , datacombos and it uses 4 tables from the database

there is one datacombo which displays names of menuitems contained in menuitem table.when one of the element in datacombo is selected then its corresponding menuitemcode from menuitem table is displayed in the textbox on the form.till this much it is working........

i have added a datagrid which is not connected to any table. i want to add the selected datacombo element and its corresponding menuitemcode displayed in the textbox in this grid when i click on the commandbutton .this is not working.......
runtime error 7005 ------ rowset not available.

on the commandbutton click event i wrote the following code---
datagrid1.columns("menuitem").text=datacombo1.text
datagrid1.columns("menuitemcode").text=txtmnucd.te xt


once this datagrid is populated then i want to save this in one of the table...
Sep 3 '07 #1
Share this Question
Share on Google+
1 Reply


hariharanmca
100+
P: 1,977
form is created which contains textboxes , labels , datacombos and it uses 4 tables from the database

there is one datacombo which displays names of menuitems contained in menuitem table.when one of the element in datacombo is selected then its corresponding menuitemcode from menuitem table is displayed in the textbox on the form.till this much it is working........

i have added a datagrid which is not connected to any table. i want to add the selected datacombo element and its corresponding menuitemcode displayed in the textbox in this grid when i click on the commandbutton .this is not working.......
runtime error 7005 ------ rowset not available.

on the commandbutton click event i wrote the following code---
datagrid1.columns("menuitem").text=datacombo1.text
datagrid1.columns("menuitemcode").text=txtmnucd.te xt


once this datagrid is populated then i want to save this in one of the table...

Did you mention the row value like


after this

Expand|Select|Wrap|Line Numbers
  1. datagrid1.Row = intRowValue
columns can able to assigen.
Expand|Select|Wrap|Line Numbers
  1.  datagrid1.columns("menuitem").text=datacombo1.text
  2.  datagrid1.columns("menuitemcode").text=txtmnucd.text 
  3.  
I am not aware of datagrid, but this are the basic concepts
Sep 3 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.