simple table in a form

Natcon67

New member
Joined
Feb 23, 2005
Messages
3
Programming Experience
Beginner
Hello, I am pretty new to this but this is what I am trying to do. I have created an excel worksheet that is a "matrix" for lack of a better word. There are about 10 input fields and then a grid of data that gets displayed depending on the fields. I have used a datagrid in VB.NET before but only to display info from a database with a DBConnection, and Dataset.

Is there a way to have the look of the excel grid on the form without having to connect to a datasource. I can put all of the algorithms in functions and display the grid based on that.



Thanks for any help.
 

Bilalq

Member
Joined
Jul 21, 2004
Messages
24
Programming Experience
3-5
If I am understanding you correctly, then you can use a datatable and add that datatable to dataset or a dataview. Then you can set the setdatabinding property of the datagrid to the dataset or the dataview and the table name. Hope this helps.
 

Natcon67

New member
Joined
Feb 23, 2005
Messages
3
Programming Experience
Beginner
Well, that is just it, I don't want to use a database. I want the form self contained and do the calculations of the textfield inputs to display in the grid. Basically like Excel does it.
 

Bilalq

Member
Joined
Jul 21, 2004
Messages
24
Programming Experience
3-5
well, datatables, dataset or dataviews don't have to have a database to work. And you need one of these to populate your grid with. What I am thinking is you need to create a datatable and put it in a dataview. With dataview, you can modify the values and the output and it all be on your machine; no database needed. You might wanna read up on Datatable and Dataview, and it is fairly easy. I think these two will be the key players for you here.
Hope that helps.
 

Natcon67

New member
Joined
Feb 23, 2005
Messages
3
Programming Experience
Beginner
Thanks a lot! That is what I am looking for. I'll read about how to do that.
 
Top Bottom