Extract value from dataset by alphabetically RSS

• • Reply
  

  maxmax

  Member

  249 Points

  530 Posts

  Extract value from dataset by alphabetically

  Nov 23, 2012 02:34 PM|LINK

  I have dataset with many records in it, now I want to extract record starting with "A, " "B" "C", D, E, F G H, I ......  individually.

  How Do i do this?

  Help me !

  thank you

  max

• • Reply
  

  chaaraan

  Contributor

  2170 Points

  484 Posts

  Re: Extract value from dataset by alphabetically

  Nov 24, 2012 01:53 AM|LINK

  Hi

  You can use DataView for Filtering the Dataset(let the values be in ur dataset named "ds")

  DataView dv = ds.Tables[0].DefaultView;

  dataView.RowFilter = "Name LIKE 'A*'"; // will fetch all the records starting with A;....

  Regards,

  Charan

• • Reply
  

  Frank Jiang ...

  All-Star

  16006 Points

  1728 Posts

  Microsoft

  Re: Extract value from dataset by alphabetically

  Nov 27, 2012 07:04 AM|LINK

  Use Linq to achieve this. for example:

  protected void Page_Load(object sender, EventArgs e)
          {
              DataTable dtTable = createDataTable();
              var querySum = (from qs in dtTable.AsEnumerable()
                              where qs.Field<string>("empname").StartsWith("S") || qs.Field<string>("empname").StartsWith("H")
                              select qs).CopyToDataTable();
              GridView1.DataSource = querySum;
              GridView1.DataBind();
          }
          
          public static DataTable createDataTable()
          {
              DataTable dt = new DataTable();
              dt.Columns.Add("empid", typeof(int));
              dt.Columns.Add("empname", typeof(string));
              dt.Columns.Add("salary", typeof(int));
              dt.Rows.Add(100, "Shakeer Hussain", 10000);
              dt.Rows.Add(101, "Shakeer", 1000);
              dt.Rows.Add(102, "Hussain", 3000);
              dt.Rows.Add(103, "Syed Shakeer Hussain", 66000);
              dt.Rows.Add(104, "diamond", 5000);
              dt.Rows.Add(105, "AABBCC", 100);
              dt.Rows.Add(106, "XXYYZZ", 4500);
              dt.Rows.Add(107, "MMKKLL", 7000);
              return dt;
          }

  Please mark the replies as answers if they help or unmark if not.
  Feedback to us
  
  Develop and promote your apps in Windows Store
  
  
  • Marked as answer by Frank Jiang - MSFT on Nov 30, 2012 09:57 AM
• • Reply
  

  sarathi125

  Star

  13599 Points

  2691 Posts

  Re: Extract value from dataset by alphabetically

  Nov 27, 2012 07:31 AM|LINK

  Hi,

  This is for a gridview, you can try the same for datatable also,

  http://myaspsnippets.blogspot.co.uk/2010/08/alphabet-paging-in-gridview.html

  Parthasarathi,
  Remember to click Mark as Answer on the post that helps to others.
  
  My Blog :MyAspSnippets
• • Reply
  

  sarathi125

  Star

  13599 Points

  2691 Posts

  Re: Extract value from dataset by alphabetically

  Nov 27, 2012 01:42 PM|LINK

  Hi,

  The following code I used to create dynamic button for sorting gridview with alphabetics...

  protected void LoadSortButtons()
      {
          int alphaAscii;
          Dictionary<string, bool> dataExistance = new Dictionary<string, bool>();
          for (int alphabetAscii = 65; alphabetAscii < 91; alphabetAscii++)
          {
              dataExistance.Add(((char)alphabetAscii).ToString(), false);
          }
          dtGrid = (DataTable)ViewState["GridTable"];
          if (dtGrid.Rows.Count > 0)
          {
              try
              {
                  foreach (DataRow dr in dtGrid.Rows)
                  {
                      if (dr[_ColumnName].ToString() != string.Empty)
                      {
                          string startCharOfRow = dr[_ColumnName].ToString().Substring(0, 1).ToUpper();
                          dataExistance[startCharOfRow] = true;
                      }
                  }
                  alphaAscii = 65;
                  foreach (KeyValuePair<String, bool> entry in dataExistance)
                  {
                      if (alphaAscii < 91)
                      {
                          if (entry.Key == (Convert.ToChar(alphaAscii)).ToString())
                          {
                              LinkButton lnkButton = new LinkButton();
                              lnkButton.ID = "lnkButton" + entry.Key;
                              lnkButton.Text = entry.Key;
                              if (entry.Value)
                              {
                                  lnkButton.Enabled = true;
                                  lnkButton.ToolTip = "Click to view " + _ColumnName + " starts with " + entry.Key + "";
                                  lnkButton.CssClass = "availSort";
                                  lnkButton.EnableTheming = true;
                                  lnkButton.Click += this.lnkButton_click;
                              }
                              else
                              {
                                  lnkButton.Enabled = false;
                                  lnkButton.ToolTip = "No " + _ColumnName + " starts with " + entry.Key + "";
                              }
                              pnlButtons.Controls.Add(lnkButton);
                          }
                          alphaAscii++;
                      }
                  }
              }
              catch (Exception ex)
              {
                  ;
              }
              finally
              {
  
              }
  
          }
      }

  Parthasarathi,
  Remember to click Mark as Answer on the post that helps to others.
  
  My Blog :MyAspSnippets
  • Marked as answer by Frank Jiang - MSFT on Nov 30, 2012 09:57 AM