Search:  
NamespacesDiscussions.NET v1.1Feedback
sql parameters
Messages   Related Types
This message was discovered on ASPFriends.com 'ngfx-sqlclient' list.
Responses highlighted in red are from those people who are likely to be able to contribute good, authoratitive information to this discussion. They include Microsoft employees, MVP's and others who IMHO contribute well to these kinds of discussions.

Alessandro Ravelli \(Calcol Informatica\)
can i pass two parameters in a command text like this?

SqlDataAdapter1.SelectCommand.Parameters("@x1111").Value = Textbox1.Text

SqlDataAdapter1.SelectCommand.Parameters("@x2222").Value = "%" & Textbox2.Text & "%"

SELECT *
FROM table
WHERE (@x1111 LIKE @x2222)

thanks!!!
Reply to this message...
 
    
William \(Bill\) Vaughn (VIP)
can i pass two parameters in a command text like this?

SqlDataAdapter1.SelectCommand.Parameters("@x1111").Value = Textbox1.Text

SqlDataAdapter1.SelectCommand.Parameters("@x2222").Value = "%" & Textbox2.Text & "%"

SELECT *
FROM table
WHERE (@x1111 LIKE @x2222)

thanks!!!
Reply to this message...
 
    
Iain Smallwood
can i pass two parameters in a command text like this?

SqlDataAdapter1.SelectCommand.Parameters("@x1111").Value = Textbox1.Text

SqlDataAdapter1.SelectCommand.Parameters("@x2222").Value = "%" & Textbox2.Text & "%"

SELECT *
FROM table
WHERE (@x1111 LIKE @x2222)

thanks!!!
Reply to this message...
 
    
William \(Bill\) Vaughn (VIP)
can i pass two parameters in a command text like this?

SqlDataAdapter1.SelectCommand.Parameters("@x1111").Value = Textbox1.Text

SqlDataAdapter1.SelectCommand.Parameters("@x2222").Value = "%" & Textbox2.Text & "%"

SELECT *
FROM table
WHERE (@x1111 LIKE @x2222)

thanks!!!
Reply to this message...
 
 
System.Data.CommandType
Ad
MBR BootFX
Best-of-breed application framework for .NET projects, developed by Matthew Baxter-Reynolds and MBR IT
 
 Copyright © Matthew Baxter-Reynolds 2001-2008. '.NET 247 Software Development Services' is a trading style of MBR IT Solutions Ltd.
Contact Us - Terms of Use - Privacy Policy - www.dotnet247.com