Click here to Skip to main content
15,904,503 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: Array Pin
Christian Graus14-Jul-05 17:56
protectorChristian Graus14-Jul-05 17:56 
GeneralVB.Net inherited from GroupBox but if I drag a control onto it at design time it is added to form's controls collection Pin
SBendBuckeye14-Jul-05 12:55
SBendBuckeye14-Jul-05 12:55 
GeneralRe: VB.Net inherited from GroupBox but if I drag a control onto it at design time it is added to form's controls collection Pin
vtalau14-Jul-05 18:34
vtalau14-Jul-05 18:34 
GeneralVB .NET: XML to Datagrid Pin
Anonymous14-Jul-05 9:54
Anonymous14-Jul-05 9:54 
GeneralRe: VB .NET: XML to Datagrid Pin
Anonymous14-Jul-05 9:57
Anonymous14-Jul-05 9:57 
GeneralRe: VB .NET: XML to Datagrid Pin
Anonymous14-Jul-05 9:59
Anonymous14-Jul-05 9:59 
GeneralProblem in Query Pin
eshban28414-Jul-05 9:47
eshban28414-Jul-05 9:47 
GeneralRe: Problem in Query Pin
Christian Graus14-Jul-05 11:27
protectorChristian Graus14-Jul-05 11:27 
eshban284 wrote:
Dim da As New SqlClient.SqlDataAdapter("SELECT * from books where '" & Me.ComboSearch.Text & "' like '" & var1 & "' ", cn)

You're putting quotes around the tablename. You shouldn't.

Also, LIKE doesn't do anything unless you put % on either side of the string. And finally, you're wide open for SQL injection attacks with this code.


Christian Graus - Microsoft MVP - C++
GeneralRe: Problem in Query Pin
J4amieC15-Jul-05 1:37
J4amieC15-Jul-05 1:37 
GeneralRe: Problem in Query Pin
Anonymous15-Jul-05 3:34
Anonymous15-Jul-05 3:34 
GeneralRe: Problem in Query Pin
eshban28415-Jul-05 7:43
eshban28415-Jul-05 7:43 
GeneralExplorer-Style ListView Pin
Brad Fackrell14-Jul-05 8:26
Brad Fackrell14-Jul-05 8:26 
GeneralComboBox binding Pin
dptalt14-Jul-05 8:24
dptalt14-Jul-05 8:24 
GeneralRe: ComboBox binding Pin
Anonymous14-Jul-05 10:53
Anonymous14-Jul-05 10:53 
GeneralValidating textbox value against a db Pin
spettiford14-Jul-05 8:12
spettiford14-Jul-05 8:12 
GeneralRe: Validating textbox value against a db Pin
Christian Graus14-Jul-05 11:28
protectorChristian Graus14-Jul-05 11:28 
GeneralRe: Validating textbox value against a db Pin
spettiford15-Jul-05 2:20
spettiford15-Jul-05 2:20 
GeneralRe: Validating textbox value against a db Pin
Dave Kreskowiak15-Jul-05 3:51
mveDave Kreskowiak15-Jul-05 3:51 
GeneralRe: Validating textbox value against a db Pin
spettiford15-Jul-05 4:20
spettiford15-Jul-05 4:20 
GeneralRe: Validating textbox value against a db Pin
spettiford15-Jul-05 5:07
spettiford15-Jul-05 5:07 
Generalmonitoring/manipulating packets Pin
buzzbusy14-Jul-05 5:55
buzzbusy14-Jul-05 5:55 
GeneralRe: monitoring/manipulating packets Pin
Dave Kreskowiak14-Jul-05 6:43
mveDave Kreskowiak14-Jul-05 6:43 
GeneralBackColor Pin
Brad Fackrell14-Jul-05 5:51
Brad Fackrell14-Jul-05 5:51 
GeneralRe: BackColor Pin
Dave Kreskowiak14-Jul-05 6:06
mveDave Kreskowiak14-Jul-05 6:06 
GeneralRe: BackColor Pin
Brad Fackrell14-Jul-05 7:20
Brad Fackrell14-Jul-05 7:20 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.