arggg...sqladapter to combo binding...urgent please...spent more then 90mins

Z

ZZZ

SqlDataAdapter sql99 = new SqlDataAdapter("select
OMSCHR,TELLER,CATEGORIE,STUKS,EENHEID,BTWCODE,P1 from ARTIKELEN order by
OMSCHR",sqlConnection3);

sql99.Fill(ds);

MessageBox.Show("1:" + ds.Tables[0].Rows.Count.ToString());
////////shows 162, so OK

MessageBox.Show("2:" + ds.Tables[0].Columns[0].ColumnName.ToString());
/////////shows OMSCHR, so OK

string temp=ds.Tables[0].Columns[0].ColumnName.ToString();

MessageBox.Show("3:" + temp);
////////show OMSCHR, so OK


combo_UCkenA_artikel.DataSource=ds.Tables[0].DefaultView;

combo_UCkenA_artikel.DisplayMember="OMSCHR";
//////displaymember = ""

combo_UCkenA_artikel.DisplayMember=ds.Tables[0].Columns[0].ColumnName.ToStri
ng(); //////displaymember = ""

combo_UCkenA_artikel.DisplayMember=temp;
//////displaymember = ""







anybody?????
 
?

=?ISO-8859-2?Q?Marcin_Grz=EAbski?=

Hi ZZZ,

I try to help you...

SqlDataAdapter sql99 = new SqlDataAdapter("select
OMSCHR,TELLER,CATEGORIE,STUKS,EENHEID,BTWCODE,P1 from ARTIKELEN order by
OMSCHR",sqlConnection3);

sql99.Fill(ds);

MessageBox.Show("1:" + ds.Tables[0].Rows.Count.ToString());
////////shows 162, so OK

MessageBox.Show("2:" + ds.Tables[0].Columns[0].ColumnName.ToString());
/////////shows OMSCHR, so OK

string temp=ds.Tables[0].Columns[0].ColumnName.ToString();

MessageBox.Show("3:" + temp);
////////show OMSCHR, so OK


combo_UCkenA_artikel.DataSource=ds.Tables[0].DefaultView;
Click to expand...

i'm not sure about above line...
The better way is to define your own DataView:

DataView dView=new DataView();
dView.Table=ds.Tables[0];
combo_UCkenA_artikel.DataSource=dView;
combo_UCkenA_artikel.DisplayMember="OMSCHR";
//////displaymember = ""

combo_UCkenA_artikel.DisplayMember=ds.Tables[0].Columns[0].ColumnName.ToStri
ng(); //////displaymember = ""

combo_UCkenA_artikel.DisplayMember=temp;
//////displaymember = ""
Click to expand...

Define "ValueMember" as a source of "displayed" data.

HTH ;-]

Marcin
 
Z

ZZZ

Define "ValueMember" as a source of "displayed" data.

what do you mean by this?




Marcin Grzêbski said:
Hi ZZZ,

I try to help you...

SqlDataAdapter sql99 = new SqlDataAdapter("select
OMSCHR,TELLER,CATEGORIE,STUKS,EENHEID,BTWCODE,P1 from ARTIKELEN order by
OMSCHR",sqlConnection3);

sql99.Fill(ds);

MessageBox.Show("1:" + ds.Tables[0].Rows.Count.ToString());
////////shows 162, so OK

MessageBox.Show("2:" + ds.Tables[0].Columns[0].ColumnName.ToString());
/////////shows OMSCHR, so OK

string temp=ds.Tables[0].Columns[0].ColumnName.ToString();

MessageBox.Show("3:" + temp);
////////show OMSCHR, so OK


combo_UCkenA_artikel.DataSource=ds.Tables[0].DefaultView;
Click to expand...

i'm not sure about above line...
The better way is to define your own DataView:

DataView dView=new DataView();
dView.Table=ds.Tables[0];
combo_UCkenA_artikel.DataSource=dView;
combo_UCkenA_artikel.DisplayMember="OMSCHR";
//////displaymember = ""

combo_UCkenA_artikel.DisplayMember=ds.Tables[0].Columns[0].ColumnName.ToStri
ng(); //////displaymember = ""

combo_UCkenA_artikel.DisplayMember=temp;
//////displaymember = ""
Click to expand...

Define "ValueMember" as a source of "displayed" data.

HTH ;-]

Marcin
Click to expand...
 
Z

ZZZ

i'm not sure about above line...
The better way is to define your own DataView:

DataView dView=new DataView();
dView.Table=ds.Tables[0];
combo_UCkenA_artikel.DataSource=dView;
Click to expand...


problem still the same








Marcin Grzêbski said:
Hi ZZZ,

I try to help you...

SqlDataAdapter sql99 = new SqlDataAdapter("select
OMSCHR,TELLER,CATEGORIE,STUKS,EENHEID,BTWCODE,P1 from ARTIKELEN order by
OMSCHR",sqlConnection3);

sql99.Fill(ds);

MessageBox.Show("1:" + ds.Tables[0].Rows.Count.ToString());
////////shows 162, so OK

MessageBox.Show("2:" + ds.Tables[0].Columns[0].ColumnName.ToString());
/////////shows OMSCHR, so OK

string temp=ds.Tables[0].Columns[0].ColumnName.ToString();

MessageBox.Show("3:" + temp);
////////show OMSCHR, so OK


combo_UCkenA_artikel.DataSource=ds.Tables[0].DefaultView;
Click to expand...

i'm not sure about above line...
The better way is to define your own DataView:

DataView dView=new DataView();
dView.Table=ds.Tables[0];
combo_UCkenA_artikel.DataSource=dView;
combo_UCkenA_artikel.DisplayMember="OMSCHR";
//////displaymember = ""

combo_UCkenA_artikel.DisplayMember=ds.Tables[0].Columns[0].ColumnName.ToStri
ng(); //////displaymember = ""

combo_UCkenA_artikel.DisplayMember=temp;
//////displaymember = ""
Click to expand...

Define "ValueMember" as a source of "displayed" data.

HTH ;-]

Marcin
Click to expand...
 
V

Vagabond Software

ZZZ said:
combo_UCkenA_artikel.DisplayMember=ds.Tables[0].Columns[0].ColumnName.ToString(); //////displaymember = ""
Click to expand...


You almost had it. Get rid of the ToString() on your DisplayMember assignment.

DataColumn dc = ds.Tables[0].Columns[0];
combo_UCkenA_artikel.DisplayMember = dc.ColumnName;

- carl
 
?

=?ISO-8859-2?Q?Marcin_Grz=EAbski?=

Define "ValueMember" as a source of "displayed" data.
what do you mean by this?
Click to expand...

I mean that "ValueMember" is a field (property) that is
get when "DisplayMember" is visible.

e.g.:
I see LastName ("DisplayMemeber") but i get FirstName
("ValueMember").

Marcin
 
Z

ZZZ

thx!!!

this did it!!



combo_UCkenA_artikel.DisplayMember=ds.Tables[0].Columns[0].ColumnName.ToStri
ng(); //////displaymember = ""


You almost had it. Get rid of the ToString() on your DisplayMember
assignment.

DataColumn dc = ds.Tables[0].Columns[0];
combo_UCkenA_artikel.DisplayMember = dc.ColumnName;

- carl
 
G

Guest

Hi Carl,

Don't you know why "str!=(str.ToString())" ?

Regards

Marcin
ZZZ said:
combo_UCkenA_artikel.DisplayMember=ds.Tables[0].Columns[0].ColumnName.ToString(); //////displaymember = ""
Click to expand...



You almost had it. Get rid of the ToString() on your DisplayMember assignment.

DataColumn dc = ds.Tables[0].Columns[0];
combo_UCkenA_artikel.DisplayMember = dc.ColumnName;

- carl
Click to expand...
 
Top