conditions on executing a query

KRN000

hello every one
i'm developing a web site using asp.net , with VB as the programming language. i want to ask: how can I implement "if else" conditions on the execution of a sql query? For example,write in the handler of a button :" IF radiobutton1 is selected THEN EXECUTE sqldatasource1 (or procedure1 ) ELSE EXECUTE sqldatasource2 ( or procedure2)". So I want execution of sql query to be appended with "IF ELSE" conditions.

thank you

elmemo

Hi dude,

So in the VB code for the handler of a button you can do something like:

Expand|Select|Wrap|Line Numbers

 
Dim cmd As New SqlClient.SqlCommand

cmd.CommandType = CommandType.StoredProcedure
 
IF checkbox1.Checked= true THEN
 
  cmd.CommandText = "sp_someProc1"

  cmd.Parameters.Add(New SqlClient.SqlParameter("paramKey1", "val1"))
 
ELSE
 
  cmd.CommandText = "sp_someProc2"

  cmd.Parameters.Add(New SqlClient.SqlParameter("paramKey1", "val1"))
 
END IF
 
cmd.ExecuteNonQuery()

Does this help?

conditions on executing a query

re: conditions on executing a query

Similar ASP / Active Server Pages bytes

/bytes/development

/bytes/it

/bytes/about