ListView binding to DataTable...

Joseph

17y19.4k

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.

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sam Hobbs17y ago
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.
Joseph17y ago
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 Hobbs17y ago
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 Choudhary17y ago

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='<%# Eval("ProductName") %>' title='<%# Eval("ProductName") %>' />

and in the codebehind bind like this ListView1.DataSource=Dtable; ListView1.DataBind();

romelevans17y ago
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 Hobbs17y ago
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.