How to get field value into label1.text with select query from AccessDatasource RSS

• • Reply
  

  hkbeer

  Member

  716 Points

  1478 Posts

  How to get field value into label1.text with select query from AccessDatasource

  Dec 30, 2012 11:30 AM|LINK

  I have a AccessDataSource control which successfully get the data from TableA of field ProductID, ProductName.

  Now I need to get Select ProductName where ProductID =1 so I type this into SelectCommand and it can display the record into Gridview, meaning the AccessDataSource is perfect.

  However, instead of Gridview, I need to get that ProductName into label1.text.

  What should be the easiest way and code for so doing ?

  Thanks

  Thanks. I will try to credit the ones who helped but most important is we really do sincerely thanks to all who have helped.
  
  www.developerfusion.com/tools/convert/csharp-to-vb/
  • Edited by hkbeer on Dec 30, 2012 11:30 AM
  • Edited by hkbeer on Dec 30, 2012 11:31 AM
• • Reply
  

  oned_gk

  All-Star

  31828 Points

  6514 Posts

  Re: How to get field value into label1.text with select query from AccessDatasource

  Dec 30, 2012 11:48 AM|LINK

  DataTable dt = ((DataView)AccessDataSource1.Select(DataSourceSelectArguments.Empty)).Table;
  Label1.Text = dt.Rows[0][0].ToString();

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

  Decker Dong ...

  All-Star

  118619 Points

  18779 Posts

  Re: How to get field value into label1.text with select query from AccessDatasource

  Dec 30, 2012 11:59 PM|LINK

  hkbeer

  hkbeer

  Hi,

  Any data source is used to bind data contents directly to the data presentation control, so you don't need to use this if you only wanna fetch a single value. Please use SqlCommand instead:

  private static void ReadOrderData(string connectionString)
  {
        string commandText = "SELECT TOP1 FieldName FROM xxx;";
        using (SqlConnection connection = new SqlConnection(connectionString))
        {
              using (SqlCommand command = new SqlCommand(commandText, connection))
              {
                    connection.Open();
                    using (SqlDataReader reader = command.ExecuteReader())
                    {
                         if(reader.Read())
                         {
                            Label1.Text = reader.GetString(fieldindex,0-based);
                         }
                    }
              }
        }
  }

  • Marked as answer by Young Yang - MSFT on Jan 08, 2013 06:44 AM