multiple data access component
-
Hi! Do you remember "continuous form" in form view in MS Access form designer? I need something like that in C# - one data source supplies multiple data forms (or custom controls dynamically placed on the form). How can I make it? thanks Hubert
I'm not quite sure what you mean since I havent been forced to use Access for a long time. But, a DataSet should be usable for multiple data views. The word abbreviation is awfully long for what it means.
-
I'm not quite sure what you mean since I havent been forced to use Access for a long time. But, a DataSet should be usable for multiple data views. The word abbreviation is awfully long for what it means.
I have meant the component which is multiplicated as many times on the form/panel as the number of records in database is, and all of these components displays data from just one datasource. In special cases this may look similar to the DataGrid bounded to data table in dataset - each row of data from the table is represented as single row of controls (TextBoxes typically) in DG. I have much more complicated data to work/visualize (about 50 data columns represented as buttons, combo boxes, text fields) so DG fails ;-( I hope this made my question more clear :-) thanks again h.
-
I have meant the component which is multiplicated as many times on the form/panel as the number of records in database is, and all of these components displays data from just one datasource. In special cases this may look similar to the DataGrid bounded to data table in dataset - each row of data from the table is represented as single row of controls (TextBoxes typically) in DG. I have much more complicated data to work/visualize (about 50 data columns represented as buttons, combo boxes, text fields) so DG fails ;-( I hope this made my question more clear :-) thanks again h.
Off hand, I'd say you have two options. First, you can add customized columns to a datagrid on the fly as you read the data from the dataset. Or second, you can enumerate the dataset and add the controls to your form on the fly. A nice sample on this site that does the second option and can be found here [^] For the first option, take a look here [^], while it may not be exactly what you need, the code does show how to add custom column types to a datagrid. Best of luck. The word abbreviation is awfully long for what it means.
-
Off hand, I'd say you have two options. First, you can add customized columns to a datagrid on the fly as you read the data from the dataset. Or second, you can enumerate the dataset and add the controls to your form on the fly. A nice sample on this site that does the second option and can be found here [^] For the first option, take a look here [^], while it may not be exactly what you need, the code does show how to add custom column types to a datagrid. Best of luck. The word abbreviation is awfully long for what it means.
hm, well, both of the above articles/codes are pretty good (and useful for other parts of my project) but it is still not what I've meant. But... in the meantime, i have made something which realizes my functionality - it is pretty simple now, but tomorrow I'm going to apply it to my project and test. And maybe I'll write a little article about writing my own DataPanel... Thanks very much for help and (again) for interesting links above H.