John Colby
jwcolby at ColbyConsulting.com
Tue Jan 10 18:12:12 CST 2006
I'm trying to set up a combo in VB programmatically. The following is what I am using: Function LoadCboService() Dim strCnn As String = My.Settings.C2DbConquestConnectionString Dim cnn As New SqlConnection(strCnn) cnn.Open() Dim strSQLService As String = "SELECT * FROM tlkpService" Dim cmd As New SqlCommand(strSQLService, cnn) Dim adpt As New SqlDataAdapter(cmd) Dim Ds As DataSet Ds = New DataSet("cboService") adpt.Fill(Ds, "cboService") cboService.DataSource = Ds.Tables("cboService") cboService.DisplayMember = Ds.Tables("cboService").Columns("RA_Rank").ToString cboService.ValueMember = Ds.Tables("cboService").Columns("RA_ID").ToString Return True End Function The function runs to cboService.DisplayMember = Ds.Tables("cboService").Columns("RA_Rank").ToString And fails with: "null reference exception was unhandled" I am trying to populate a combo box with two columns of a table, the PK column, and the "display" or text value column. What am I doing wrong? John W. Colby www.ColbyConsulting.com