combobox with data binding

31 Aug 2006 12:03 AM

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

31 Aug 2006 6:23 AM

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

Show quoteHide quote

"GS" <gsmsnews.microsoft.co***@msnews.Nomail.com> schreef in bericht
news:uUMNoDJzGHA.5048@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
>
>

31 Aug 2006 6:11 PM

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.

Show quoteHide quote

"Cor Ligthert [MVP]" <notmyfirstn***@planet.nl> wrote in message
news:ut2iGXMzGHA.1256@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" <gsmsnews.microsoft.co***@msnews.Nomail.com> schreef in bericht
> news:uUMNoDJzGHA.5048@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
> >
> >
>
>