Hi,

I need to populate the search results from a DB2 table into the datagrid..Can someone help me with this?

my connection is as shown below..

Dim cString As String = "Provider=IBMDADB2.1;Password=" + sPW + ";User ID=" + sUID + ";Data Source=" + sDS + ";Connect Timeout=45"

Dim cn As OleDbConnection
cn = New OleDbConnection()
cn.ConnectionString = cString
cn.Open()

I am trying to use OleDbDataAdapter,OleDbCommand,DataSet to load the datagrid with the search results.

Please some one help me!

Thanx a Bunch in Advance.