Exception in the DataGridView for a BLOB field in .Net 2008

R

Ryan

I am trying to hide a coloumn if the DataType is Byte (Byte[]) but still get
the exception; how do I either hide this field or not add to the DataGridView?
the following exception occured in the DataGridView:
system.argumentexception:parameter is not valid

Dim oAdapter As OracleDataAdapter
oAdapter = New OracleDataAdapter(sSQL, oConn)
myDataSet = New DataSet()
oAdapter.Fill(myDataSet)

myBindingSource = New BindingSource()
myBindingSource.DataSource = myDataSet

With myDataSet.Tables(0)
For i As Integer = 0 To myDataSet.Tables(0).Columns.Count - 1
If InStr(.Columns(i).DataType.ToString, GetType(Byte).ToString) > 0
Then
myDataSet.Tables(0).Columns(i).ColumnMapping = MappingType.Hidden
End If
Next
End With

DataGridView1.DataSource = myDataSet.Tables(0)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help With Custom Paging in DataGridView - VB.Net 2008 0
how to create table in sql server from either a datagridview or excelfile 1
New columns and update problem...! 3
export datagridview to text file and import text file to sql servertable on the fly 2
Binding to the same TextBox and record index in a DataGridView until enter is hit 1
OutOfMemoryException when using a datagridview in a panel 1
Clearing a dataGridView for reuse 3
DataGridView with a ComboBox column error (listing objects) 3

Top