I can't sort my combo box. Please Help!

[raj]

When I try to sort my combo box I get the following error.

"Cannot sort a ComboBox that has a DataSource set. Sort the data using the
underlying data model."

--------------------------------THe code is given below.
String strSQL;

strSQL = "SELECT .......... WHERE C.Client = '" +
this.cboClient. SelectedValue + "' ";
userTable = manager.GetData Table(strSQL,"u serList");

cmbUserList.Dat aSource = userTable;
cmbUserList.Dis playMember = "FollowUpPerson ";
cmbUserList.Val ueMember = "FollowUpPerson ";

cmbUserList.Sel ectedIndex = -1;
cmbUserList.Sor ted = true;
------------------------------------------------
I do really appreciate any ideas or sugessions.

Thanks

raj

[John Kn [MS]]

Raj,
The combobox will not fill if it has 'sorted' preselected in the design
process.

--------------------

Thread-Topic: I can't sort my combo box. Please Help!
thread-index: AcS/xvw8xLfcJGSzQJK vGzE1Rk/XNQ==
X-WBNR-Posting-Host: 203.28.214.209
From: =?Utf-8?B?cmFq?= <ra*@discussion s.microsoft.com >
Subject: I can't sort my combo box. Please Help!
Date: Sun, 31 Oct 2004 19:58:02 -0800
Lines: 24
Message-ID: <0F************ *************** *******@microso ft.com>
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
Newsgroups: microsoft.publi c.dotnet.genera l
NNTP-Posting-Host: TK2MSFTNGXA03.p hx.gbl 10.40.1.29
Path: cpmsftngxa10.ph x.gbl!TK2MSFTNG XA03.phx.gbl
Xref: cpmsftngxa10.ph x.gbl microsoft.publi c.dotnet.genera l:150745
X-Tomcat-NG: microsoft.publi c.dotnet.genera l

When I try to sort my combo box I get the following error.

"Cannot sort a ComboBox that has a DataSource set. Sort the data using the
underlying data model."

--------------------------------THe code is given below.
String strSQL;

strSQL = "SELECT .......... WHERE C.Client = '" +
this.cboClient .SelectedValue + "' ";
userTable = manager.GetData Table(strSQL,"u serList");

cmbUserList.Da taSource = userTable;
cmbUserList.Di splayMember = "FollowUpPerson ";
cmbUserList.Va lueMember = "FollowUpPerson ";

cmbUserList.Se lectedIndex = -1;
cmbUserList.So rted = true;
------------------------------------------------
I do really appreciate any ideas or sugessions.

Thanks

raj

{\rtf1\ansi\ans icpg1252\deff0\ deflang1033{\fo nttbl{\f0\fnil\ fprq2\fcharset0
MS Sans Serif;}{\f1\fsw iss\fcharset0 Arial;}}
{\*\generator Msftedit 5.41.21.2500;}\ viewkind4\uc1\p ard\f0\fs20 Cheers,\par
\par
johnKn [MS-SDK]\par
\par
\par
\par
-Please do not send email directly to this alias. This alias is for \par
newsgroup purposes only\par
\par
-This posting is provided "AS IS" with no warranties, and confers no
rights.\par
\par
-To provide additional feedback about your community experience please send
\par
e-mail to: sd*****@microso ft.com\par
\f1\par
}

[raj]

Hi John Kn
No. the combobox field is not preselected. It is setted to 'FALSE'.
U'r correct it will not get populated if I selected to 'TRUE'.
But my combo box is get populated (As it SORT's seleted to 'FALSE') but I
can't sort at the moment. Do u have any suggestions? I'm trying to explicitly
code as 'cmbUserList.So rted = true;' This will crashes my aplication with
error message.

Thanks
raj

"John Kn [MS]" wrote:

Raj,
The combobox will not fill if it has 'sorted' preselected in the design
process.

--------------------

Thread-Topic: I can't sort my combo box. Please Help!
thread-index: AcS/xvw8xLfcJGSzQJK vGzE1Rk/XNQ==
X-WBNR-Posting-Host: 203.28.214.209
From: =?Utf-8?B?cmFq?= <ra*@discussion s.microsoft.com >
Subject: I can't sort my combo box. Please Help!
Date: Sun, 31 Oct 2004 19:58:02 -0800
Lines: 24
Message-ID: <0F************ *************** *******@microso ft.com>
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
Newsgroups: microsoft.publi c.dotnet.genera l
NNTP-Posting-Host: TK2MSFTNGXA03.p hx.gbl 10.40.1.29
Path: cpmsftngxa10.ph x.gbl!TK2MSFTNG XA03.phx.gbl
Xref: cpmsftngxa10.ph x.gbl microsoft.publi c.dotnet.genera l:150745
X-Tomcat-NG: microsoft.publi c.dotnet.genera l

When I try to sort my combo box I get the following error.

"Cannot sort a ComboBox that has a DataSource set. Sort the data using the
underlying data model."

--------------------------------THe code is given below.
String strSQL;

strSQL = "SELECT .......... WHERE C.Client = '" +
this.cboClient .SelectedValue + "' ";
userTable = manager.GetData Table(strSQL,"u serList");

cmbUserList.Da taSource = userTable;
cmbUserList.Di splayMember = "FollowUpPerson ";
cmbUserList.Va lueMember = "FollowUpPerson ";

cmbUserList.Se lectedIndex = -1;
cmbUserList.So rted = true;
------------------------------------------------
I do really appreciate any ideas or sugessions.

Thanks

raj

{\rtf1\ansi\ans icpg1252\deff0\ deflang1033{\fo nttbl{\f0\fnil\ fprq2\fcharset0
MS Sans Serif;}{\f1\fsw iss\fcharset0 Arial;}}
{\*\generator Msftedit 5.41.21.2500;}\ viewkind4\uc1\p ard\f0\fs20 Cheers,\par
\par
johnKn [MS-SDK]\par
\par
\par
\par
-Please do not send email directly to this alias. This alias is for \par
newsgroup purposes only\par
\par
-This posting is provided "AS IS" with no warranties, and confers no
rights.\par
\par
-To provide additional feedback about your community experience please send
\par
e-mail to: sd*****@microso ft.com\par
\f1\par
}

[Cor Ligthert]

Raj,

As the message tells, do you have when you use the datasource have to use a
sorted datasource, what is very easy to do.

Typed here so watch typos

DataView dv = new DataView(userTa ble);
dv.Sort = "FollowUpPerson ";
cmbUserList.Dat aSource = dv;

>cmbUserList.Di splayMember = "FollowUpPerson ";
>cmbUserList.Va lueMember = "FollowUpPerson ";

I hope this helps?

Cor

[C-Services Holland b.v.]

raj wrote:

When I try to sort my combo box I get the following error.

"Cannot sort a ComboBox that has a DataSource set. Sort the data using the
underlying data model."

--------------------------------THe code is given below.
String strSQL;

strSQL = "SELECT .......... WHERE C.Client = '" +
this.cboClient. SelectedValue + "' ";
userTable = manager.GetData Table(strSQL,"u serList");

cmbUserList.Dat aSource = userTable;
cmbUserList.Dis playMember = "FollowUpPerson ";
cmbUserList.Val ueMember = "FollowUpPerson ";

cmbUserList.Sel ectedIndex = -1;
cmbUserList.Sor ted = true;
------------------------------------------------
I do really appreciate any ideas or sugessions.

Thanks

raj

Why not simply sort in the SQL query (order by FolowUpPerson)?

Rinze

[Patrick]

You can also just sort on the .DefaultView property of the datatable,
instead of creating a new dataview object.

"Cor Ligthert" <no************ @planet.nl> wrote in message
news:e%******** **********@TK2M SFTNGP12.phx.gb l...

Raj,

As the message tells, do you have when you use the datasource have to use
a sorted datasource, what is very easy to do.

Typed here so watch typos

DataView dv = new DataView(userTa ble);
dv.Sort = "FollowUpPerson ";
cmbUserList.Dat aSource = dv;

>cmbUserList.Di splayMember = "FollowUpPerson ";
>cmbUserList.Va lueMember = "FollowUpPerson ";

I hope this helps?

Cor

[raj]

Hi
It works now.
I would like to thanks John, Cor Ligthert. Patrick and C-Serveces Holland,
for assisting me to solve this problem. Once again, many thanks.

Cheers

raj
"C-Services Holland b.v." wrote:

raj wrote:

When I try to sort my combo box I get the following error.

"Cannot sort a ComboBox that has a DataSource set. Sort the data using the
underlying data model."

--------------------------------THe code is given below.
String strSQL;

strSQL = "SELECT .......... WHERE C.Client = '" +
this.cboClient. SelectedValue + "' ";
userTable = manager.GetData Table(strSQL,"u serList");

cmbUserList.Dat aSource = userTable;
cmbUserList.Dis playMember = "FollowUpPerson ";
cmbUserList.Val ueMember = "FollowUpPerson ";

cmbUserList.Sel ectedIndex = -1;
cmbUserList.Sor ted = true;
------------------------------------------------
I do really appreciate any ideas or sugessions.

Thanks

raj

Why not simply sort in the SQL query (order by FolowUpPerson)?

Rinze