| re: Thinking through a project design....
if you make a good structure for your property data (w i gave you w the 2
tables was out the top of my head youll have to think about it a bit more)
you should be able to do it w 1 datagrid (you would be feeding the datagrid
new sql querries) to select w querry you have to show you could use a
listbox next to the datagrid (this way you wont need a tabcontrol w 28
datagrids, and i think it wil look better, certainly if you adjust the
datagrid and col properties a bit)
eric
"scorpion53061" <scorpion_53061nospamhereplease@yahoo.com> wrote in message
news:%23QavQvPuDHA.2448@TK2MSFTNGP09.phx.gbl...[color=blue]
> Hi Eric,
>
> Thank you for your help.
>
> I did what you said, created another table in the database which will hold
> the fields for this grid.
>
> Do you think I am going to have to using this method create a new datagrid
> for each tab control form?
>
> "EricJ" <ericRéMoVe@ThiSomnipack.be> wrote in message
> news:3fccbdb2$0$2877$ba620e4c@reader1.news.skynet. be...[color=green]
> > not really but i think i can set you on the right path adjust this to[/color][/color]
your[color=blue][color=green]
> > needs
> > if you create 2 tables in your db
> > 1 will hold an id, a propertytype and a property name (property type[/color][/color]
would[color=blue][color=green]
> > be 1 of your 28)
> > 2 wil hold an id, a property id, a value and a user (the property's will
> > belong to someone)
> >
> > now you can create sets of properties in your db
> >
> > in the datagrid make a selection of all rows in the 1table connected to[/color]
> the[color=green]
> > 2nd table (for a prop type)
> > this gives you a 2 col datagrid
> > (drgmain is the datagrid)
> > create a tablestyle and set the first col to readonly (you don't want[/color][/color]
the[color=blue][color=green]
> > user to edit your property names)
> > \\
> > dsForm = New DataSet("data")
> > dsForm = SqlHelper.ExecuteDataset(gstrCnn, CommandType.Text,[/color]
> strSql)[color=green]
> > Dim ts As New DataGridTableStyle
> > ts.MappingName = "Table"
> > dgrMain.TableStyles.Clear()
> > dgrMain.SetDataBinding(dsForm, "Table")
> > dgrMain.TableStyles.Add(ts)
> > ts.GridColumnStyles(0).Width = 0
> > ts.GridColumnStyles(0).ReadOnly = True
> > ts.GridColumnStyles(1).Width = 100
> > //
> >
> > then all you have left is to save the data in the database
> > i think this could be something that would work wel in a bound structure
> >
> > anyway i hope it helps
> >
> > eric
> >
> > "scorpion53061" <scorpion_53061nospamhereplease@yahoo.com> wrote in[/color]
> message[color=green]
> > news:ey89$MOuDHA.2712@TK2MSFTNGP11.phx.gbl...[color=darkred]
> > > Hi eric
> > >
> > > Thank you for your advice.
> > >
> > > I need to somehow on the datagrid control allow this to be a control a[/color]
> > user[color=darkred]
> > > can enter data and then I can assign its contents to variables (first[/color]
> > column[color=darkred]
> > > e.g. say "Author" then the next column the user would enter a value[/color][/color]
> which[color=green][color=darkred]
> > > when they clicked submit I would read and assign to variable.
> > >
> > > Do you know of a link that would help with this?
> > > "EricJ" <ericRéMoVe@ThiSomnipack.be> wrote in message
> > > news:3fcc8cce$0$3241$ba620e4c@reader0.news.skynet. be...
> > > > yust some thoughts
> > > >
> > > > 1) a tabcontrol w 28 pages w a datagrid (in the datagrid you would[/color][/color]
> have[color=green]
> > 2[color=darkred]
> > > > cols 1 for the question 2nd for the answer)
> > > >
> > > > 2) a treeview 28 main nodes
> > > > option a) clicking under the main node you split thing up a bit[/color][/color][/color]
in[color=blue][color=green][color=darkred]
> > > > subnodes
> > > > clicking a subnode would show a panel w your
> > > > textboxes (you could fill this dinamically for the selected node)
> > > > b) have a subnode for each detail (you can jump to[/color][/color][/color]
the[color=blue][color=green][color=darkred]
> > > next
> > > > detail automatically when the user made a valid input)
> > > > 3) a listbox, or combo w your 28 main items calling a panel again (w[/color][/color]
> the[color=green][color=darkred]
> > > > textboxes) keep in mind panels give scrollbars so the limited[/color][/color]
> resolution[color=green][color=darkred]
> > > > dousnt have to be a problem
> > > >
> > > > hope it helped
> > > >
> > > > eric
> > > >
> > > > "scorpion53061" <scorpion_53061nospamhereplease@yahoo.com> wrote in
> > > message
> > > > news:uyV5VANuDHA.3196@TK2MSFTNGP11.phx.gbl...
> > > > > vb.net windows app to be used on college campuses.
> > > > >
> > > > > I need to somehow think this through and come up with some ideas .[/color][/color]
> You[color=green][color=darkred]
> > > > guys
> > > > > have been good to me as far as helping me think things through so[/color][/color][/color]
I[color=blue][color=green]
> > felt[color=darkred]
> > > > > pretty confident coming here.
> > > > >
> > > > > I have a situation where I need to account for 28 different types[/color][/color][/color]
of[color=blue][color=green][color=darkred]
> > > data
> > > > > entering situations each having about 35 textboxes and[/color][/color][/color]
corresponding[color=blue][color=green][color=darkred]
> > > > labels
> > > > > and each textbox has a variable. If the textbox is empty when they[/color]
> > click[color=darkred]
> > > > > submit the variable is left blank which is important for how I[/color][/color]
> format[color=green][color=darkred]
> > > the
> > > > > data. When clicking submit these variables would be recorded to a[/color]
> > access[color=darkred]
> > > > > database.
> > > > >
> > > > > If you were me, how would you approach this situation? Would you[/color][/color][/color]
use[color=blue]
> a[color=green][color=darkred]
> > > tab
> > > > > control? Do you think it would be poor practice to have 2 tabs[/color][/color][/color]
where[color=blue][color=green]
> > the[color=darkred]
> > > > > user had to click a second tab(planning for a min 800x600 screen[/color][/color][/color]
and[color=blue][color=green]
> > not[color=darkred]
> > > > all
> > > > > textboxes would fit on one tab).
> > > > >
> > > > > Your thoughts please and they are much appreciated.
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >[/color]
> >
> >[/color]
>
>[/color]
| 
