Member Avatar for sainiricha

Input from text box as text(not number) and by button click need all values from the sql table to be viewed in the datagridview.
eg:deptname as input in textbox, and by button click take all values from table matching this deptname and get output in datagridview.
Can anyone help me out in this matching of textbox value as text of mine.As its matching integer type but text type is not getting matched.

  • 2 Contributors
  • 5 Replies
  • 109 Views
  • 20 Hours Discussion Span
  • Latest Post Latest Post by Jx_Man
Member Avatar for Jx_Man 
SELECT * FROM TableName WHERE ColumnName like '%" & textBox1.Text & "%'
commented: got it +1
Member Avatar for sainiricha

Hello i've tried this,but still i'm not getting the output...:-(...
Can u suggest some other solutions??

Member Avatar for Jx_Man

show your code and what the effort of that.

Member Avatar for sainiricha

Thankuu its working now...i was leaving space between ' &"..
thankuu..i was trying to solve this from past many days..but couldn't solve...now i could with ur help...:-)

Member Avatar for Jx_Man

you're welcome sainiricha.
don't forget to mark this thread solved.
happy coding friend :)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.