ListView binding to DataTable...

Question

I have a DataTable with three columns (Name, CasesToday, CasesWeek) and a ListView with a View of GridView. I need to bind the ListView to display the contents of the DataTable at runtime. I have tried gvUsers.ItemsSource = dtUsers2.DefaultView; but this only shows "System.Data...." and not the actual value from the row. I have scoured the Internet for the solution to this but can only find SQL and XML binding; none the reference DataTables. Any help would be much appreciated.

Sam Hobbs · Answer

If you had said WPF I would have been able to help you. Note that others answered using ASP but I assume you are not using ASP. For WPF there are ways to bind a ListView. Also if you use a DataGridView then you can just do as I suggested for a ListView; that is set the DataGridView's DataSource to the DataTable.

Joseph · Answer

Unfortunately ListView does not have a definition for DataSource. I have worked with GridViews in web development but this is my first WPF application and I am missing the .DataSource property. I just removed the ListView and added a DataGrid from the WPF Toolkit. Now I can do dataGrid.ItemsSource = dt.DefaultView;. This seems to work pretty well. Thank you all for your input.

Sam Hobbs · Answer

Perhaps it is as simple as setting the ListView's DataSource to the DataTable as in: ListView1.DataSource = dt; Where dt is the DataTable.

Amit Choudhary · Answer

hi friend try this code ' runat=server> runat=server style=border-top: 1px solid #CCCCCC; border-right: 1px solid #999999; border-bottom: 1px solid #999999; border-left: 1px solid #CCCCCC; background: #E0E0E0 url(Images/bg-photo-frame.jpg) repeat-x; padding: 4px;>  alt=' ' title=' ' /> and in the codebehind bind like this ListView1.DataSource=Dtable; ListView1.DataBind();

romelevans · Answer

This is pretty simple if I'm understanding it correctly. If you're just trying to bind the list to the gridView all you have to do is: gvUsers.datasource = listname; gvUsers.bind(); Of course in the gridview you'll need to put the binding information such as &lt %# ... % &gt if you're using a template view for each of the columns. Or am I missing something? Romel Evans

Sam Hobbs · Answer

The easiest way is to use the IDE to generate the code for you. You can create a useful application without writing much code or any code yourself. Look at the Data Walkthroughs to see what can be done. You don't need to do the walkthroughs in any order; do the ones you want to in the order you want to. Most of the walkthroughs use the DataGridView which is like a ListView but the general concepts are the same for both. My guess is that you will decide to use a DataGridView instead.