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]]

Re: combobox with data binding

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" <gsmsnews.micro soft.comGS@msne ws.Nomail.comsc hreef in bericht
news:uUMNoDJzGH A.5048@TK2MSFTN GP05.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]

Re: combobox with data binding

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]" <notmyfirstname @planet.nlwrote in message
news:ut2iGXMzGH A.1256@TK2MSFTN GP02.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" <gsmsnews.micro soft.comGS@msne ws.Nomail.comsc hreef in bericht
news:uUMNoDJzGH A.5048@TK2MSFTN GP05.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

>
>