MBR IT/.NET 247 : oleDbDataAdapter/DataSet - data to ListView. on microsoft.public.dotnet.framework.windowsforms

oleDbDataAdapter/DataSet - data to ListView.

Messages

Related Types

This message was discovered on microsoft.public.dotnet.framework.windowsforms.

Przemek

Hi.
1. Have u got any solution to add data from DataSet or oleDbDataAdapter to
ListView control, with no adding row after row but complex (big part of
data) like with DataGrid control?

2. How can I add row after row from DataSet?
3. Is reader make read operation with SQL statement, to take row after row
in real time operating on DB file? Or it is buffering data somewhere?
Thanks, for wrote.

Reply to this message...

Sijin Joseph

1. The ListView control does not support DataBinding, so you will have
to add data row after row only.

2.

foreach(DataRow row in ds.Rows)
{
    ListViewItem item = new ListViewItem();
    item.Text = row[0];
    item.SubItems.Add(row[1]);
    .
    .
    .
    item.SubItems.Add(row[n]);

    listView.Items.Add(item);
}

3. A datareader does not buffer data, the rows are read from a TDS that
is returned by SQL server.

Sijin Joseph
http://www.indiangeek.net
http://weblogs.asp.net/sjoseph

Przemek wrote:
[Original message clipped]

Reply to this message...

	System.Data.DataRow
	System.Data.DataSet
	System.Web.UI.DataBinding
	System.Web.UI.WebControls.DataGrid
	System.Windows.Forms.DataGrid
	System.Windows.Forms.ListView
	System.Windows.Forms.ListViewItem

MBR BootFX
Best-of-breed application framework for .NET projects, developed by Matthew Baxter-Reynolds and MBR IT

	Copyright © Matthew Baxter-Reynolds 2001-2008. '.NET 247 Software Development Services' is a trading style of MBR IT Solutions Ltd.
	Contact Us - Terms of Use - Privacy Policy - www.dotnet247.com