POS Application

[carlbutler7]

this is code i use to call in a record using a textbox and a button

Dim SearchProduct As String = txtBC.Text

    Dim con As OleDbConnection = New OleDbConnection("Provider = Microsoft.Jet.OLEDB.4.0;" & _
                 "Data Source = '" & Application.StartupPath & "\POS.mdb'")
    ' Use wildcard' 
    Dim cmd As OleDbCommand = New OleDbCommand("SELECT * FROM Products WHERE SKU= '" & SearchProduct & "' ", con)
    'Like state = "SELECT * FROM Products WHERE SKU Like '%" & SearchProduct & "%' ", con

    con.Open()

    Dim myDA As OleDbDataAdapter = New OleDbDataAdapter(cmd)
    Dim POSDataSet1 As DataSet = New DataSet()
    If myDA.Fill(POSDataSet1, "Products") Then
        DataGridView1.DataSource = POSDataSet1.Tables("Products").DefaultView
    ElseIf txtBC.Text = "" Then
        BarcodeError2.Show()
    Else
        BarcodeError.Show()
    End If
    txtBC.Text = ""

it inserts the record into my datagridview fine but when i enter the second it just replaces the first record scanned. can some please help me, i have been trying for days to get this to function correctly

Thanks
Carl

[kRod]

You are creating a new DataSet each time you run this code so the table your DataGridView is using gets refreshed with only the record queried for.

You might try using the Datareader to fill the DataTable you're using for your DataGridViews DataSource.

You can create some variables to hold the values read from the DataReader then ad them to your DataTable
You should also use the BindingSource so its easier to refresh your DataGridView.

 Dim newRow As DataRow = ds.Tables("TableName").NewRow()

        newRow("FieldName1") = "SomeValue1"
        newRow("FieldName1") = "SomeValue2"

        ds.Tables("TableName").Rows.Add(newRow)

Give me a shout if you need help setting it up.

[carlbutler7]

hi yeah i forgot to mention i'm a total beginner in programming so your help in setting it up would be greatly appreciated :D

[carlbutler7]

Please someone?

[Reverend Jim]

If you are a total beginner in programming then I suggest a simpler project to get your feet wet.

[GeekPlease]

You can create a datatable to served as a data container. Because the last filter will be replaced when you use your code. Or, you can copy your dataset then add the next filter to it so you can populate your datagrid properly.

Take a look at this.

http://msdn.microsoft.com/en-us/library/system.data.dataset.copy.aspx

Hope this help