Gridview Data binding not displaying

Question

0.00/5 (No votes)

See more:

I know this is simple and I must be overlooking something. I'm trying on a button click to bind and display my gridview. I've tried a few variations on the code. Either the page posts back or it does not post back either way a gridview never populates on the button click. If I change the code and have it populate on page load then works fine but once moved to button click nothing appears.

I've tried with and with out the post back.

 Protected Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click

    If IsPostBack = False Then
        gridview.DataSource = SqlDataSource1
        gridview.DataBind()
    End If

End Sub

thanks

Posted 5-May-15 2:59am

Troy Bryant

Add a Solution

Comments

Mantu Singh 5-May-15 9:08am

try removing If IsPostBack = False Then
because when u click button page is posted to server got it!!

1 solution

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)

Mantu Singh · Accepted Answer · 2015-05-05T03:11:00

Solution 1

try this

VB

Protected Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click

        If IsPostBack = True Then
            gridview.DataSource = SqlDataSource1
            gridview.DataBind()
        End If

    End Sub

Posted 5-May-15 3:11am

Mantu Singh

Comments

Troy Bryant 5-May-15 9:14am

Nope neither of these worked. I originally didnt have post back but I've made it true and then deleted same results

Mantu Singh 5-May-15 9:18am

have you configured sqldatasource properly

Troy Bryant 5-May-15 9:22am

To my knowledge yes. Its a simple select command nothing fancy

Mantu Singh 5-May-15 9:28am

my sample code works just fine

<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:SKTConnectionString %>"
SelectCommand="SELECT * FROM [CLIENT_DET_SMRY]">
<asp:Button ID="Button1" runat="server" Text="Next" onclick="Button1_Click" />

<asp:GridView ID="GridView1" runat="server" Height="168px" Width="322px">

<asp:Button ID="Button2" runat="server" onclick="Button2_Click" Text="Button" />

Select the Sql data source & see its ConnectionString property like
Data Source=sqlserver;Initial Catalog=DB;User ID=sa;Password=password

if not click small arrow top right corner of sqldatasource & Configure datasource...

Troy Bryant 5-May-15 10:16am

I deleted the grid and ds and just started fresh seemed to have fixed it. I have no idea what happened but thanks for the help

Mantu Singh 5-May-15 10:34am

welcome !!