Why doesn't my datagrid display my new results?

Question

0.00/5 (No votes)

See more:

datagrid named grdSearch
Function called is name sqlSelect
My code displays everything when the form first loads. but when i click search i want only the london people of the database to show. however, my datagrid doesnt update

VB

 Function sqlSelect(ByVal sqlString As String)
        da = New OleDbDataAdapter(sqlString, con)
        da.Fill(ds, "Results")
        Return ds
    End Function

Imports System.Data.SqlClient
Public Class frmSearch
    Dim db As New clsDBConnector
    Dim ds As New DataSet
    Private Sub frmSearch_Load(sender As Object, e As EventArgs) Handles MyBase.Load
        db.connect()

        Dim sqlselect As String
        Dim ds As New DataSet

        sqlselect = "SELECT * FROM tbltest"
        ds = db.sqlSelect(sqlselect)
        grdSearch.DataSource = ds.Tables(0)
    End Sub

    Private Sub btnSearch_Click(sender As Object, e As EventArgs) Handles btnSearch.Click

        Dim sqlselect As String
        Dim ds As New DataSet

        sqlselect = "SELECT * FROM tbltest WHERE City= 'London'"
        ds = db.sqlSelect(sqlselect)
        grdSearch.DataSource = ds.Tables(0)

    End Sub
End Class

thanks

Posted 9-Sep-14 2:31am

MrSuperT

Updated 9-Sep-14 2:37am

v2

Add a Solution

Comments

member33 9-Sep-14 9:02am

need to wrap your initial load in not ispostback

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

MrSuperT · Answer 1 · 2014-09-11T00:41:00

i had to clear my dataset.

VB

Imports System.Data.SqlClient
Public Class frmSearch
    Dim db As New clsDBConnector
    Dim ds As New DataSet
    Private Sub frmSearch_Load(sender As Object, e As EventArgs) Handles MyBase.Load
        db.connect()
        Dim sqlselect As String

        sqlselect = "SELECT * FROM tbltest"
        ds = db.sqlSelect(sqlselect)
        grdSearch.DataSource = ds.Tables(0)
    End Sub

    Private Sub btnSearch_Click(sender As Object, e As EventArgs) Handles btnSearch.Click
        Dim sqlselect As String
        ds.Clear()
        sqlselect = "SELECT * FROM tbltest WHERE City= 'London'"
        ds = db.sqlSelect(sqlselect)
        grdSearch.DataSource = ds.Tables(0)
    End Sub
End Class

Manikandan MAC · Answer 2 · 2014-09-09T03:26:00

Solution 1

Also i am not sure whether we need to provide return type for the SqlSelect function.

Please check whether the dataset returns any data.

Posted 9-Sep-14 3:26am

Manikandan MAC

Comments

MrSuperT 9-Sep-14 10:23am

yes first time it loads. data is returned. when the button btnSearch is clicked nothing happens

ChauhanAjay · Answer 3 · 2014-09-09T05:52:00

Solution 2

Try changing the frmSearch_Load in the following manner

VB

Private Sub frmSearch_Load(sender As Object, e As EventArgs) Handles MyBase.Load
        db.connect()

        Dim sqlselect As String
        Dim ds As New DataSet
        If Not Page.IsPostBack Then
           sqlselect = "SELECT * FROM tbltest"
           ds = db.sqlSelect(sqlselect)
           grdSearch.DataSource = ds.Tables(0)
        End If
    End Sub

Hope the above code helps.

Posted 9-Sep-14 5:52am

ChauhanAjay

Comments

MrSuperT 11-Sep-14 6:11am

when i add this a get an error message saying "Page is not declared" so i replaced Page with my form name but then it says tht "IsPostBack is not a member of..."

ChauhanAjay 11-Sep-14 6:19am

are you using windows forms or web forms

MrSuperT 11-Sep-14 6:21am

im using windows form

Why doesn't my datagrid display my new results?

3 solutions

Solution 3

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us