cory thompson

cory thompson

  • NA
  • 29
  • 27.1k

TableAdapter Question

Aug 26 2011 4:30 PM
I am a complete newbie and am stuck trying to return a search using a tableadapter. If I use the following code I can search my database from whatever I enter into my textbox, but I use a tableadapter with radio buttons in my code which filters down my datagrid.
If I use my current code to search then my radio buttons stop working.
da.SelectCommand = new SqlCommand(string.Format("SELECT * from LoggedCalls where [Fault] like '%{0}%' OR [Resolution] like '%{0}%'", tboxSearch.Text), cs);

how can I convert this to use a tableadapter?

Thanks

Answers (8)