Member Avatar for tanvirahmad

Hi experts
I m using Hindi font In a text box,
these textbox has a value "uxn ¼dS'k½",
when I use select command for searching "uxn ¼dS'k½" value,
it's show error.
I know this error is showing for ' which is in "uxn ¼dS'k½" , how to search m I

  • 3 Contributors
  • 2 Replies
  • 63 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by kvprajapati

Recommended Answers

All 2 Replies

Member Avatar for finito

can you please elaborate the last line of your question

Member Avatar for kvprajapati

Parameterized query will solve your problem.

cn=new SqlConnection("connection_string")
cmd=new SqlCommand("select * from table1 where col1=@col1",cn)
cmd.Parameter.AddWithValue("@col1",textbox1.text")
....
Edited by kvprajapati because: n/a
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.