Results 1 to 4 of 4

Thread: [RESOLVED] Data coding error regarding filter

  1. #1

    Thread Starter
    New Member
    Join Date
    Jun 2019
    Posts
    8

    Resolved [RESOLVED] Data coding error regarding filter

    Code:
    Imports System.Data.SqlClient
    Public Class Form1
        Private connectionString As String = GetConnectinString()
        Private Connection As New SqlConnection(ConnectionString)
        Private adapter As SqlDataAdapter
        Private datast As DataSet
        Private sql As String
        Private app As String
    
        Private Sub Form1_Load(sender As Object, e As EventArgs) Handles MyBase.Load
            'TODO: This line of code loads data into the 'IMDbDataSet.table3' table. You can move, or remove it, as needed.
            Me.Table3TableAdapter.Fill(Me.IMDbDataSet.table3)
            ComboBox1.SelectedIndex = 0
            OpenSQLConnection()
        End Sub
    
        Private Function GetConnectinString() As String
            Return "Data source=DESKTOP-52R55AK\SQLEXPRESS01;Initial Catalog=IMDb;" &
                "Integrated Security=True; MultipleActiveResultSets=True"
        End Function
        'DESKTOP-52R55AK\SQLEXPRESS01
    Code:
     Private Sub Button7_Click_1(sender As Object, e As EventArgs) Handles Button7.Click
            Dim dv As DataView
            dv = New DataView(ds.Tables(0), "type = 'business' ", "type Desc", DataViewRowState.CurrentRows)
            DataGridView1.DataSource = dv
        End Sub
    Name:  ok.jpg
Views: 262
Size:  7.7 KB

  2. #2
    eXtreme Programmer .paul.'s Avatar
    Join Date
    May 2007
    Location
    Chelmsford UK
    Posts
    25,458

    Re: Data coding error regarding filter

    Assuming type is a field, try...

    Code:
    dv = New DataView(ds.Tables(0), "[type] = 'business' ", "[type] Desc", DataViewRowState.CurrentRows)

  3. #3

    Thread Starter
    New Member
    Join Date
    Jun 2019
    Posts
    8

    Re: Data coding error regarding filter

    Code:
      Dim ds As New DataSet
    Code:
     DataGridView1.DataSource = ds.Tables(0)
    Code:
    Private Sub Button7_Click_1(sender As Object, e As EventArgs) Handles Button7.Click
            Dim dv As DataView
            dv = New DataView(ds.Tables(0), "genres = 'horror' ", "type Desc", DataViewRowState.CurrentRows)
            DataGridView1.DataSource = dv
        End Sub
    Name:  err.PNG
Views: 230
Size:  11.1 KB

    add few things and edited other error occured

  4. #4
    eXtreme Programmer .paul.'s Avatar
    Join Date
    May 2007
    Location
    Chelmsford UK
    Posts
    25,458

    Re: [RESOLVED] Data coding error regarding filter

    Me.IMDbDataSet.table3?

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width