add from a drop down list

[Guest]

Hello All!

I have a ddl that holds the 12 months of the year. I added the items in the
collection of the ddl control. But how can take that selected month from the
ddl and save it to my table. Are there any examples on this. There is alot
of stuff for binding data from a table. But I can't find anything to show me
how to add from a ddl.

TIA!!!

Rudy

 

[Jason Bentley]

Rudy, you will have to handle data inserts/updates yourself. There is
an example at
http://www.dotnetjunkies.com/quicks...t/aspplus/samples/webforms/data/datagrid4.src
which uses VB and a datagrid but the concept is the same.

Jason Bentley
http://geekwithblogs.net/jbentley

 

[Guest]

Hi Jason!
Thanks for the response. I looked at the sample. It looks like I would
treat a ddl just like I would treat a text box. In my form, I have a
combination of textboxe, and ddl. Would I treat them the same, even though I
have the items loaded in the the collection of the prorperties. Here is a
snipit. Only code for the textboxes.

Private Sub UpdateTextBox()
Dim conUpdTxt As SqlConnection
Dim cmdUpdtxt As SqlCommand
Dim parmReturnValue As SqlParameter
Dim intResult As Integer

conUpdTxt = New
SqlConnection("Server=localhost;UID=*****;PWD=****;Database=Golfer")

cmdUpdtxt = New SqlCommand("NCProfile", conUpdTxt)
cmdUpdtxt.CommandType = CommandType.StoredProcedure

cmdUpdtxt.Parameters.Add("@artist", txtArtist.Text)
cmdUpdtxt.Parameters.Add("@movie", txtMovie.Text)
cmdUpdtxt.Parameters.Add("@notwork", txtNotWork.Text)
conUpdTxt.Open()
cmdUpdtxt.ExecuteNonQuery()

Thanks!!!

Rudy

 

[Jason Bentley]

Rudy, that is right. You will treat the ddl just as you would the
textboxes. You will have to either pull the item's value or selected
text but you probably all ready know that.

Jason Bentley
http://geekswithblogs.net/jbentley

 

[Guest]

Hi Jason!

Not to beat a dead horse. So if I had the following for my textbox.

cmdUpdtxt.Parameters.Add("@notwork", txtNotWork.Text)
Then my ddl should look something like this.
cmdUpdtxt.Parameters.Add("@year",.....Now this is where I'm a little
confused. Do I put ddlyear, the name of my control ddlYear.SelectedItem.Text)
Thanks for all your help on this!

Rudy

 

[Guest]

Hello Jason,

Just wanted to let you know, after messing around with it tonight, I finally
got it!
cmdUpdtxt.Parameters.Add("@birthmonth", ddlMonth.SelectedValue) is the way
that worked for me. Thanks again for your help, it's appreciated!!

Rudy