Member Avatar for ginnipig

Hello all,
I have a DataGridView that is being populated via SQL with one table and is being filtered by Stock Code. I need to sort the view of one Stock Code by Nutrient names, but the sequence number is in anther SQL table. it would be easy if i could put the sequence in one table but that's not possible, and there are 47 nutrients that need to be sorted in the View. eg, Calories, Fat, Saturated, Trans, cholesterol...

thank you
kyle :)

  • 2 Contributors
  • 2 Replies
  • 130 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by ginnipig
Member Avatar for adam_k

Why is it not possible to put the sequence in the same query you are populating your DataGridView?

Please show us these 2 queries.

Member Avatar for ginnipig

I figured it out :), i wasn't aware that you could use one SQL select statement for multiple tables.

Private Sub BindDataNutr()
        Dim conn As OleDbConnection
        Dim SqlStr As String
        Dim dsNutr As New DataSet
        Dim daNutr As New OleDbDataAdapter
        conn = New OleDbConnection(SysproSqlString())
        conn.Open()
        SqlStr = "SELECT SBSI_NutritionalInfo.StockCode, SBSI_NutritionalInfo.Nutrient, SBSI_NutritionalInfo.Per100g, SBSI_NutritionalValues.NutrientUom, SBSI_NutritionalInfo.DataSource, SBSI_NutritionalValues.LabelSeq FROM  SBSI_NutritionalInfo INNER JOIN SBSI_NutritionalValues ON SBSI_NutritionalInfo.Nutrient = SBSI_NutritionalValues.Nutrient where StockCode = '" & Trim(Tbx_StkCode.Text) & "' ORDER BY SBSI_NutritionalValues.LabelSeq"
        'SqlStr = "select * From dbo.SBSI_NutritionalInfo where StockCode = '" & Trim(Tbx_StkCode.Text) & "'"
        daNutr = New OleDbDataAdapter(SqlStr, conn)
        daNutr.Fill(dsNutr)
        DGV_NutrUp.DataSource = dsNutr.Tables(0)
        DGV_NutrUp.Columns("LabelSeq").Visible = False
        DGV_NutrUp.Columns("StockCode").Visible = False
    End Sub
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.