Problem Binding Lisbox Value With The Database Column?

Jan 30, 2008

Hello Friends..
I m using vwd 2005 express along with sql express.
I have a web form with different server controls like textboxes, labels, radiobuttons, listboxes etc.
lets focus on listbox.

1..For example lets say,ListBox contains 5 email addresses of the user.

Now my main problem is when i submit my webform,all my data from
textboxes, radiobuttons etc gets stored into the sqldatabase.
   But the data from my ListBox doesnot get stored into the database.
   But when i manually select a single email address from the listbox the email address in this case gets saved in the database.

But as soon as i choose multiple email address then in this case only
the first email address only gets saved but not the rest.
   How to over come this problem? I have a column named "email" in my table in the database.
   Can some one explain me this with the code(C#)..

2..And my 2nd question is i dont want to manually select the data from the listbox so that it gets saved into the database.
    I want all the email address in the Listbox gets automatically selected as soon as i click on the save button at
    the end of my web form.

   Any idea on how to approach this,friends?

Thanks..


Jack.

View 6 Replies

SQL 2000 View Has Column Binding Errors

Feb 11, 2008

Hi all,

I'm trying to use a SQL 2000 view in one of my sources. The view isnt anything special --- just three tables that have been unioned together. All these three tables have the EXACT same datatypes as well as column names. There are no constraints on these tables (yet). There is an identity seed on the first ID column. However, when I try to access this view, it generates the following error:

Server: Msg 4502, Level 16, State 1, Procedure MyView, Line 5
View or function 'MyView' has more column names specified than columns defined.
Server: Msg 4413, Level 16, State 1, Line 1
Could not use view or function 'MyView' because of binding errors.

Does anybody have any experience with this?

View 3 Replies View Related

Using Stored Procedures To Set The Default Value Or Binding Of A Table Column

Nov 24, 2007

I want to be able to have an authorized person set or change the default values of a table column in a SQL Database. I have a stored procedure that sets the default which works fine: ALTER PROCEDURE [dbo].[addMyConst]ASBEGINALTER TABLE [dbo].[tbl1]ADD DEFAULT 70 FOR [Auto_ourlim]END(I still need to put parameters in so that I can run the stored procedure from a form, but for now....)
To change it I know that I have to drop the constraint first like this:
ALTER PROCEDURE [dbo].[dropmyValue]ASALTER TABLE [dbo].[tbl1] DROP CONSTRAINT [Auto_ourlim]
The problem is that when I execute the procedure I get the error that "Auto_ourlim" is not a constraint so it does not drop the Default Value. When I go over to SQL Server Management Studio Express I can see why:
If I open up the table and open up the Constraints the constraint is "DF__tbl1__Auto_ourli__5FB337D6". I could change the DROP CONSTRAINT to this, and that works, but it changes every time I add the new DEFAULT VALUE. I don't know how to get around it. Is there a way to put wildcards around "Auto_our" in DROP CONSTRAINT [Auto_ourlim}? Any suggestions would be welcome...even if there's a totally different way to do it.
What I'm trying to ultimately accomplish is this: Column1 (AutoLimits) would be user insert to the database and then in the database it would MINUS Column2 (Auto_ourlim - set with the default value) = Column3 (Difference - a computed field in the database)
Steve

View 2 Replies View Related

Binding A DataSource Table Column To A Form Object (RadioButtons)

Oct 25, 2006

Hi,

I have a little question. I have an application which interfaces with a SQL Express Database.   On a form, I want to bind a control which is made of several Radio buttons to a table column which is in fact a varchar(1). This is the picture:

        Table column: OptVisualRpt varchar(1)

        Screen control: 2 radio buttons

                                    rb_VisRPTbImp_O    for "yes"

                                    rb_VisRPTbImp_N    for "no"

I'm really scratching my head as how I can bind a single table column to my radio buttons controls.   I think that I just can't this way but rather have to use an intermediate variable or control.

Solution 1?

I thought of using a local variable that I would set to "y" or "n" following "CheckedChanged" events fired from radio buttons but I don't know how to bind this variable to my table column.

Solution 2?

I thought of placing a hidden text control into my form, which one would be binded to my table column, that I would also set to "y" or "n" following "CheckedChanged" events fired from radio buttons.

Any of these solutions which would be feasible or any more neat way to do it?

Many thanks in advance,

Stéphane