Select all rows from gridview where column contain any words of a string RSS

• • Reply
  

  Mojorz

  Member

  3 Points

  22 Posts

  Select all rows from gridview where column contain any words of a string

  Nov 07, 2012 12:21 PM|LINK

  string[] word = txt_search.Text.Split(' ');
  foreach (string str in word)
  {
  SqlConnection connection = Connection.GetDBConnection();
  connection.Close();
  select statement like str

  cmd.Parameters.AddWithValue("@tag", str);

  da.Fill(ds);

  GridView1.DataSource = ds;
  GridView1.DataBind();
  }

  Any ideas ?

  • Edited by Mojorz on Nov 07, 2012 01:15 PM
  • Moved by tmorton on Nov 07, 2012 01:33 PM
  • Edited by Mojorz on Nov 07, 2012 02:06 PM
  • Moved by tmorton on Nov 08, 2012 12:50 PM
• • Reply
  

  RichardY

  Star

  8376 Points

  1573 Posts

  Re: Select all rows from gridview where column contain any words of a string

  Nov 07, 2012 12:29 PM|LINK

  Please post more complete code.  We need to see what is in the foreach loop.

• • Reply
  

  oned_gk

  All-Star

  31511 Points

  6431 Posts

  Re: Select all rows from gridview where column contain any words of a string

  Nov 07, 2012 11:58 PM|LINK

  Gridview dont have multiple selection. Gridview has selectedindex and selectedvalue property to determine which row you select.

  Programming to simplify, dont look for hard way
• • Reply
  

  Frank Jiang ...

  All-Star

  16006 Points

  1728 Posts

  Microsoft

  Re: Select all rows from gridview where column contain any words of a string

  Nov 09, 2012 05:21 AM|LINK

  Search records in GridView and highlight results:

  http://www.aspdotnet-suresh.com/2011/12/search-records-in-gridview-and.html

  Gridview Search word with highlight:

  http://www.dotnetspark.com/kb/1971-gridview-search-word-with-high-light-using.aspx

  ASP.NET GridView with search option

  http://www.codeproject.com/Articles/43018/ASP-NET-GridView-with-search-option-SearchableGrid

  Please mark the replies as answers if they help or unmark if not.
  Feedback to us
  
  Develop and promote your apps in Windows Store
  
  
  • Edited by Frank Jiang - MSFT on Nov 14, 2012 09:50 AM
  • Edited by Young Yang - MSFT on Dec 11, 2012 02:40 AM
  • Marked as answer by Frank Jiang - MSFT on Dec 12, 2012 06:37 AM
• • Reply
  

  Mojorz

  Member

  3 Points

  22 Posts

  Re: Select all rows from gridview where column contain any words of a string

  Nov 09, 2012 05:06 PM|LINK

  Thanks this links were a great help  .

  Thanks for your time .