simple table in a form

[Natcon67]

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]

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]

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]

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]

Thanks a lot! That is what I am looking for. I'll read about how to do that.