asp.net c# Multiple search from tabels
I want to make a search function but I need to search from 1 textbox in the entire columns.
For example I have: 
string select="Select * From tableName where(Name like'%" + texbox1.text.Tostring() + "'";
sqldatasource1.selectocmmand = select;

via that code I Can only search in table Name , what if I Want to search from the same texbox another colum.
Sql database 2008
Thanks
asp.net c# Multiple search from tabels
===

I want to make a search function but I need to search from 1 textbox in the entire columns.
For example I have: 
string select="Select * From tableName where(Name like'%" + texbox1.text.Tostring() + "'";
sqldatasource1.selectocmmand = select;

via that code I Can only search in table Name , what if I Want to search from the same texbox another colum.
Sql database 2008
Thanks