data grid data binding

[turrican]

Hello again. My question this week is about data binding. For example, I am attempting to write a simple program taht will have a form with a list box and a data grid as controls. Just for fun I will make it a list of my DVD's that can be searched by genre.

So if the user selects comedy in the list box, a list of all of the comedy dvds will apear in the datagrid. My problem though is that I am setting the datagrid's data source and data member properties at design time. What I did was generate a dataset for each genre of movie (Kids, action, drama, etc) but I can only bind one data set to the flex grid at a time, so when the user chooses the first option the movies appear in the data grid perfectly but when you chose the next option nothing shows up. Can I set these properties so that the databinding takes place after the user makes his choice? I guess this would be considered at run time right?

[wyrd]

Your can bind your DataGrid at run-time like this...

dataGrid1.DataSource = theSource;

[turrican]

so would that be datagrid1.datasource = datasetname or the path to the file?

[wyrd]

You'd more then likely want to bind the DataGrid to one of the tables inside your DataSet.

[turrican]

Im sorry could you give me an example of the proper syntax for that? Im sorry,if this is a lame question, Im new and Im learning this stuff on my own with only a few books and this forum. thank you for your time and your help.

BTW your picture kind of scares me.

[wyrd]

Well, I'm more or less the blind leading the blind here as I've never actually written anything in ADO.NET yet, but if I'm not mistaken the proper syntax would be..

 

(Using C#)

dataGrid1.DataSource = yourDataSet.Tables["YourTable"].DefaultValue;

 

(Using VB)

dataGrid1.DataSource = yourDataSet.Tables("YourTable").DefaultValue

[turrican]

I still cant get it to work. It seems like I should bind the dataset to the datagrid after the user makes his selection in the listbox. I need to bind the data that corresponds with the selection in the listbox. does this make sense?

[Nerseus]

Use the following search in your .NET help (minus the double quotes):

"walkthrough creating master detail windows"

 

It should find a how-to titled "Walkthrough: Creating a Master-Detail Windows Form" which shows how to bind a ListBox and as you click entries, it automatically fills a filtered DataGrid.

 

-nerseus

[turrican]

Thanks Nerseus!! I see your in Az, me too. Mesa. Thanks again.

[Nerseus]

No problem :)

 

If you want to learn how to bind a grid to a DataView (a filtered, sorted view of a DataTable) let me know. Ah heck, here it is...

 

Assume you have two tables, Table1 and Table2, which both contain a key column named State. You want to show a list of cities from Table2 that match the state currently chosen from Table1 (which is bound to a listbox).

string state = listBox1.Text;

DataView dv = new DataView(ds.Tables["Table2"], "state = '" + state.Replace("'", "''") + "'", "Cityname", DataViewRowState.CurrentRows);

dataGrid1.DataSource = dv;

 

-Nerseus