I would like to know how to insert data from multiple data controls into one column in a database.

An example of the data to be inserted would be a project number as such: SP-2006-01

I would like to use 2 DropDownList controls for the possible values such as SP and 2006. In addition, I would like to allow the user to type the last bit of information 01 into a textbox control.

Currently I am using a single text box for this data. I want more control over what possible values the user is allowed to input.

In essence:
DropDownList1 + "-" + DropDownList2 + "-" + TextBox1 = P_NUM (SP-2006-01)

Thanks!

You have the idea.

DropDownList1.SelectedValue + "-" + DropDownList2.SelectedValue + "-" + TextBox1.Text

Jim

That looks like is should work; however when I type the DropDownList1.Selected, the Intellisense tells me 'DropDownList1 is not defined.' I don't understand? I went to the Properties box for the control, and copy/pasted the name from the ID column.

This control is embedded in the 'Insert' template of a 'FormView' web contol. Do I need to reference the control in a particular fashion since it is in the template?

Yes you need to refernce it differently, EX:
dim ddl1 as new dropdownlist
ddl1 = FormView1.FindControl("DropDownList1")

Then use ddl1 in your string.

ddl1.SelectedValue + .....

Thanks, that works great!

Glad to help.. :) glad you got it working

Jim

I have noticed that this code creates two entries in the database. I believe it is because there are actually two Inserts taking place.

The first occurs when this code is run:

    Sub InsertPROJECTNUMBER()

        Dim ProjectNumber_Param As String
        Dim TYPEPROJECTNUMBERDropDownList As New DropDownList
        Dim YEARPROJECTNUMBERDropDownList As New DropDownList
        Dim NUMPROJECTUMBERTextBox As New TextBox

        TYPEPROJECTNUMBERDropDownList = FormView1.FindControl("TYPEPROJECTNUMBERDropDownLi st")
        YEARPROJECTNUMBERDropDownList = FormView1.FindControl("YEARPROJECTNUMBERDropDownLi st")
        NUMPROJECTUMBERTextBox = FormView1.FindControl("NUMPROJECTUMBERTextBox")

        ProjectNumber_Param = TYPEPROJECTNUMBERDropDownList.SelectedValue + "-" + YEARPROJECTNUMBERDropDownList.SelectedValue + "-" + NUMPROJECTUMBERTextBox.Text

        SqlDataSource1.InsertParameters("PROJECTNUMBER").D efaultValue = ProjectNumber_Param
        SqlDataSource1.Insert()

    End Sub

The second is when the 'Insert' LinkButton's click event is fired on the FormView control. This is used to insert the remaining information from the other databound controls of the FormView into the database.

This creates a double entry into the database. How would I go about setting the InsertParameter("ProjectName") equal to the same value that it would have had if I had kept the original databind for the original PROJECTNUMBERTextbox on the FormView?