combobox with data binding

[GS]

I created a combobox on a form, and setup project data source connection,
carted a table, a view for the table:
create view vw_Favorite as select code + '=:' + value from codetable where
codetablename= 'Favorite' and sequence 0

that went fine except it adds top (10) percent after select. I then proceed
to set data binding on the combo box, I just could not point it to the view
and get the desired result. however if I create a stored procedure, I was
able to see one row in the combobox when I run the form

what have I missed?
VB studio express 2005
-------------- the sp is defined as:

CREATE PROCEDURE dbo.FinCoUrl
as
SELECT code + '+:' + value AS Addr
FROM CodeTable
WHERE (codeTableName = 'FinCoUrl') AND (sequence 0)

/* SET NOCOUNT ON */
RETURN
create procedure sp_favorite as select code

[Cor Ligthert [MVP]]

GS,

-------------- the sp is defined as:

CREATE PROCEDURE dbo.FinCoUrl
as
SELECT code + '+:' + value AS Addr
FROM CodeTable
WHERE (codeTableName = 'FinCoUrl') AND (sequence 0)

/* SET NOCOUNT ON */
RETURN

This is SQL transact language code for that are special newsgroups.

This newsgroup is about the .Net VB language code.
Not all what can be used in Visual studio even if that is limited to VB
Express

Cor
"GS" <gs**********************@msnews.Nomail.comschre ef in bericht
news:uU**************@TK2MSFTNGP05.phx.gbl...

>I created a combobox on a form, and setup project data source connection,
carted a table, a view for the table:
create view vw_Favorite as select code + '=:' + value from codetable where
codetablename= 'Favorite' and sequence 0

that went fine except it adds top (10) percent after select. I then
proceed
to set data binding on the combo box, I just could not point it to the
view
and get the desired result. however if I create a stored procedure, I was
able to see one row in the combobox when I run the form

what have I missed?
VB studio express 2005
-------------- the sp is defined as:

CREATE PROCEDURE dbo.FinCoUrl
as
SELECT code + '+:' + value AS Addr
FROM CodeTable
WHERE (codeTableName = 'FinCoUrl') AND (sequence 0)

/* SET NOCOUNT ON */
RETURN
create procedure sp_favorite as select code

[GS]

thx, I see you mentioned in another thread an easier way to fill a combo
box instead of using the somewhat flaky vb express 2005 design time
facility.

"Cor Ligthert [MVP]" <no************@planet.nlwrote in message
news:ut**************@TK2MSFTNGP02.phx.gbl...

GS,

-------------- the sp is defined as:

CREATE PROCEDURE dbo.FinCoUrl
as
SELECT code + '+:' + value AS Addr
FROM CodeTable
WHERE (codeTableName = 'FinCoUrl') AND (sequence 0)

/* SET NOCOUNT ON */
RETURN

This is SQL transact language code for that are special newsgroups.

This newsgroup is about the .Net VB language code.
Not all what can be used in Visual studio even if that is limited to VB
Express

Cor
"GS" <gs**********************@msnews.Nomail.comschre ef in bericht
news:uU**************@TK2MSFTNGP05.phx.gbl...

I created a combobox on a form, and setup project data source connection,
carted a table, a view for the table:
create view vw_Favorite as select code + '=:' + value from codetable

where

codetablename= 'Favorite' and sequence 0

that went fine except it adds top (10) percent after select. I then
proceed
to set data binding on the combo box, I just could not point it to the
view
and get the desired result. however if I create a stored procedure, I

was

able to see one row in the combobox when I run the form

what have I missed?
VB studio express 2005
-------------- the sp is defined as:

CREATE PROCEDURE dbo.FinCoUrl
as
SELECT code + '+:' + value AS Addr
FROM CodeTable
WHERE (codeTableName = 'FinCoUrl') AND (sequence 0)

/* SET NOCOUNT ON */
RETURN
create procedure sp_favorite as select code