Need a little help with this code please.

apg1985 · 03-28-2008, 03:38 AM

Hi, Ive got a dropdownlist which selects stored procedures from SQL and it works fine for 2 but i really want it to have more then 2 has anyone got any ideas? CODE BELOW

SQLConnection = New SqlConnection("Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirector y|\Animals.mdf;Integrated Security=True;User Instance=True")
SQLCommand = New SqlCommand
SQLCommand.CommandType = CommandType.StoredProcedure
If DropDownList.SelectedItem.Value = 0 Then
SQLCommand.CommandText = "spcatinsert"
Else
SQLCommand.CommandText = "spdoginsert"
EndIf

mandava · 04-01-2008, 01:23 AM

i dont know which language you are programming in.
but i think you can try using either if..elseif..elseif..end statement or probably a switch statement.

apg1985 · 04-01-2008, 02:22 AM

vb.net and your right i used the else statment and it worked fine with no bugs.

Thanks

alemcherry · 04-01-2008, 02:23 AM

You can do more else If ,a s much as you want. I guess you need to learn the programming basics

mandava · 04-01-2008, 03:22 AM

Quote:

Originally Posted by apg1985

vb.net and your right i used the else statment and it worked fine with no bugs.

Thanks

no prob. you're welcome.

03-28-2008, 03:38 AM	#1 (permalink)
apg1985 Senior Googler Join Date: Jul 2007 Posts: 131 Thanks: 0 Thanked 3 Times in 3 Posts	Need a little help with this code please. Hi, Ive got a dropdownlist which selects stored procedures from SQL and it works fine for 2 but i really want it to have more then 2 has anyone got any ideas? CODE BELOW SQLConnection = New SqlConnection("Data Source=.\SQLEXPRESS;AttachDbFilename=\|DataDirector y\|\Animals.mdf;Integrated Security=True;User Instance=True") SQLCommand = New SqlCommand SQLCommand.CommandType = CommandType.StoredProcedure If DropDownList.SelectedItem.Value = 0 Then SQLCommand.CommandText = "spcatinsert" Else SQLCommand.CommandText = "spdoginsert" EndIf

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
help with conversion code - installed by code is not firing	rebmyster	Google AdWords & AdSense Forum	0	03-04-2008 07:07 AM
These code mean ...?	tigerbin	Web Design, Coding & Programming Forum	0	01-08-2007 03:15 PM
Google Code: Summer of Code	Randy	Google and Open Source	6	06-04-2005 11:38 AM
Code?	JshLnsctt	Web Design, Coding & Programming Forum	9	02-12-2005 06:38 AM
I need help with this bit of code - php	pleasant	Web Design, Coding & Programming Forum	9	10-31-2004 04:46 AM

04-01-2008, 01:23 AM	#2 (permalink)
mandava Googler Join Date: Mar 2008 Location: India Posts: 64 Thanks: 0 Thanked 2 Times in 2 Posts	i dont know which language you are programming in. but i think you can try using either if..elseif..elseif..end statement or probably a switch statement.

04-01-2008, 02:22 AM	#3 (permalink)
apg1985 Senior Googler Join Date: Jul 2007 Posts: 131 Thanks: 0 Thanked 3 Times in 3 Posts	vb.net and your right i used the else statment and it worked fine with no bugs. Thanks

04-01-2008, 02:23 AM	#4 (permalink)
alemcherry Senior Googler Join Date: Jun 2006 Posts: 148 Thanks: 1 Thanked 4 Times in 4 Posts	You can do more else If ,a s much as you want. I guess you need to learn the programming basics

GoogleCommunity Sponsor
Use coupon "forum" for 50% Off!


Sponsored Links