System.Data.DataViewManagerListItemTypeDescriptor Combobox

[Guest]

This is for a Win form.

The code below causes combo box to have
"System.Data.DataViewManagerListItemTypeDescriptor" in the drop down box.
What I'm I missing in my code to get the data out of the SP into the combo
box?

string sProc = "prGet_LicenseCode";
using (SqlConnection oCn = new
SqlConnection(sConnString))
{
using (SqlCommand oCmd = new
SqlCommand(sProc, oCn))
{
oCn.Open();
oCmd.CommandType =
CommandType.StoredProcedure;

oCmd.Parameters.Add("@sLicenseYear",
SqlDbType.NChar, 6);

oCmd.Parameters["@sLicenseYear"].Value = txtLicYear.Text;

SqlDataAdapter oDa = new
SqlDataAdapter();

oDa.SelectCommand = oCmd;
DataSet ds=new DataSet();
oDa.Fill(ds);

int numTables = ds.Tables.Count;
//No table no records.
if (numTables < 1)
{
MessageBox.Show("No License
Codes found for that year.", "No record found", MessageBoxButtons.OK);

}
else
{
cboPrivilege.DataSource = ds;
}
}
}

 

[Ollie Riches]

Your bindings for the ComboBox are not complete, you want something like
this I believe:

//DataViewManager provided through the DataSet.DefaultViewManager
property
this.comboBox1.DataSource=ds.DefaultViewManager;

//display "someTable.SomeID" value in the ComboBox
this.comboBox1.DisplayMember="someTable.SomeID";


Where 'someTable' and 'someTable.SomeID' are replaced with the value you
require.

HTH

Ollie Riches

 

[Guest]

No, still comes up with error in combo box.
this.cboPrivilege.DataSource = ds.DefaultViewManager;
this.cboPrivilege.DisplayMember = "SALES_REVENUE.LICENSE_CODE";

Your bindings for the ComboBox are not complete, you want something like
this I believe:

//DataViewManager provided through the DataSet.DefaultViewManager
property
this.comboBox1.DataSource=ds.DefaultViewManager;

//display "someTable.SomeID" value in the ComboBox
this.comboBox1.DisplayMember="someTable.SomeID";


Where 'someTable' and 'someTable.SomeID' are replaced with the value you
require.

HTH

Ollie Riches

This is for a Win form.

The code below causes combo box to have
"System.Data.DataViewManagerListItemTypeDescriptor" in the drop down box.
What I'm I missing in my code to get the data out of the SP into the combo
box?

string sProc = "prGet_LicenseCode";
using (SqlConnection oCn = new
SqlConnection(sConnString))
{
using (SqlCommand oCmd = new
SqlCommand(sProc, oCn))
{
oCn.Open();
oCmd.CommandType =
CommandType.StoredProcedure;


oCmd.Parameters.Add("@sLicenseYear",
SqlDbType.NChar, 6);

oCmd.Parameters["@sLicenseYear"].Value = txtLicYear.Text;

SqlDataAdapter oDa = new
SqlDataAdapter();

oDa.SelectCommand = oCmd;
DataSet ds=new DataSet();
oDa.Fill(ds);

int numTables = ds.Tables.Count;
//No table no records.
if (numTables < 1)
{
MessageBox.Show("No License
Codes found for that year.", "No record found", MessageBoxButtons.OK);

}
else
{
cboPrivilege.DataSource =
ds;
}
}
}

 

[Kevin Yu [MSFT]]

Hi Cadel,

Please try to change cboPrivilege.DataSource = ds; to

this.cboPrivilege.DataSource = ds.Tables[0];
this.cboPrivilege.DisplayMember = "SALES_REVENUE.LICENSE_CODE"; //if
SALES_REVENUE.LICENSE_CODE is the column name.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."

 

[Guest]

Kevin your right again. I had the table name AND the column name like Ollie
told me, but when I just have the column name it worked.

Thanks.

 

[Kevin Yu [MSFT]]

You're welcome.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."