Cannot find column [System.Data.DataRowView]

EDN Admin · Aug 25, 2012

Below is an image of my code and the error:
<img alt="" src="http://social.msdn.microsoft.com/Forums/getfile/157158
Further below is my entire code block:
<p style="margin-bottom:0in; margin-bottom:.0001pt; line-height:normal; text-autospace:none
<span style="font-size:9.5pt; font-family:Consolas; color:blue using<span style="font-size:9.5pt; font-family:Consolas System;
<p style="margin-bottom:0in; margin-bottom:.0001pt; line-height:normal; text-autospace:none
<span style="font-size:9.5pt; font-family:Consolas; color:blue using<span style="font-size:9.5pt; font-family:Consolas System.Collections.Generic;
<p style="margin-bottom:0in; margin-bottom:.0001pt; line-height:normal; text-autospace:none
<span style="font-size:9.5pt; font-family:Consolas; color:blue using<span style="font-size:9.5pt; font-family:Consolas System.ComponentModel;
<p style="margin-bottom:0in; margin-bottom:.0001pt; line-height:normal; text-autospace:none
<span style="font-size:9.5pt; font-family:Consolas; color:blue using<span style="font-size:9.5pt; font-family:Consolas System.Data;
<p style="margin-bottom:0in; margin-bottom:.0001pt; line-height:normal; text-autospace:none
<span style="font-size:9.5pt; font-family:Consolas; color:blue using<span style="font-size:9.5pt; font-family:Consolas System.Drawing;
<p style="margin-bottom:0in; margin-bottom:.0001pt; line-height:normal; text-autospace:none
<span style="font-size:9.5pt; font-family:Consolas; color:blue using<span style="font-size:9.5pt; font-family:Consolas System.Linq;
<p style="margin-bottom:0in; margin-bottom:.0001pt; line-height:normal; text-autospace:none
<span style="font-size:9.5pt; font-family:Consolas; color:blue using<span style="font-size:9.5pt; font-family:Consolas System.Text;
<p style="margin-bottom:0in; margin-bottom:.0001pt; line-height:normal; text-autospace:none
<span style="font-size:9.5pt; font-family:Consolas; color:blue using<span style="font-size:9.5pt; font-family:Consolas System.Windows.Forms;
<p style="margin-bottom:0in; margin-bottom:.0001pt; line-height:normal; text-autospace:none
<span style="font-size:9.5pt; font-family:Consolas; color:blue using<span style="font-size:9.5pt; font-family:Consolas System.Data.SqlClient;
<p style="margin-bottom:0in; margin-bottom:.0001pt; line-height:normal; text-autospace:none
<span style="font-size:9.5pt; font-family:Consolas
<p style="margin-bottom:0in; margin-bottom:.0001pt; line-height:normal; text-autospace:none
<span style="font-size:9.5pt; font-family:Consolas; color:blue
<p style="margin-bottom:0in; margin-bottom:.0001pt; line-height:normal; text-autospace:none
<span style="font-size:9.5pt; font-family:Consolas; color:blue namespace<span style="font-size:9.5pt; font-family:Consolas WindowsFormsApplication1
<p style="margin-bottom:0in; margin-bottom:.0001pt; line-height:normal; text-autospace:none



<span style="color:blue public <span style="color:blue partial <span style="color:blue
class <span style="color:#2B91AF Form1 : 
{

<span style="color:blue private <span style="color:#2B91AF DataTable _table;
<p style="margin-bottom:0in; margin-bottom:.0001pt; line-height:normal; text-autospace:none


{

InitializeComponent();

}
<p style="margin-bottom:0in; margin-bottom:.0001pt; line-height:normal; text-autospace:none

<span style="color:blue private <span style="color:blue void button1_Click(<span style="color:blue object sender,

{

();

<span style="color:blue for (<span style="color:blue int i = 0; i < listBox1.SelectedItems.Count; i++)

names.Add(listBox1.SelectedItems.ToString());


<span style="color:blue string filter = (names.Count != 0)

? <span style="color:#A31515 "CompanyName in (" + <span style="color:blue
string.Join(<span style="color:#A31515 ",", names) + 
: 
<span style="color:blue var view = <span style="color:blue new

view.RowFilter = filter;

dataGridView1.DataSource = view;

}
<p style="margin-bottom:0in; margin-bottom:.0001pt; line-height:normal; text-autospace:none

<span style="color:blue private <span style="color:blue void Form1_Load(<span style="color:blue object sender,

{

<span style="color:#2B91AF SqlConnection cs = <span style="color:blue
new <span style="color:#2B91AF SqlConnection(<span style="color:#A31515 "Data Source=EXCEL-PC;Initial Catalog=NORTHWIND.MDF;Integrated Security=True");

<span style="color:#2B91AF SqlDataAdapter da = <span style="color:blue
new <span style="color:#2B91AF SqlDataAdapter(<span style="color:#A31515 "Select Distinct CompanyName From Customers Order By CompanyName", cs);
<p style="margin-bottom:0in; margin-bottom:.0001pt; line-height:normal; text-autospace:none

_table = <span style="color:blue new 
da.Fill(_table);
<p style="margin-bottom:0in; margin-bottom:.0001pt; line-height:normal; text-autospace:none

listBox1.DataSource = _table;

listBox1.DisplayMember = 
listBox1.ValueMember = 
}

}
<p style="margin-bottom:0in; margin-bottom:.0001pt; line-height:normal; text-autospace:none
<span style="font-size:9.5pt; font-family:Consolas }

As you can probably tell, I am trying to pass several selected items from a ListBox to a DataGridView. My source data is the good old Northwind DB, in SQL Server. Of course I dont have a Field named System.Data.DataRowView. I think
thats the problem here. Why would C# not convert the items in the ListBox to an actual Field name in the DB, and pass THAT item to the DataGridView???

Thanks everyone!! <hr class="sig Ryan Shuell

View the full article

Cannot find column [System.Data.DataRowView]

EDN Admin

Well-known member

Similar threads