having problem in gridview.databind

Question

0.00/5 (No votes)

See more:

Hello Friends,

I am using grid view to show my data, but its not working any data.

code of aspx page:-

ASP.NET

<asp:GridView runat="server" ID="gh1" AutoGenerateColumns="false" EmptyDataText="No">
                    <Columns>
                    <asp:TemplateField HeaderText="Product Name">

                    <ItemTemplate>
                    <asp:Label runat="server" ID="lbl1" Text='<%Eval("PName")%>'></asp:Label>
                    </ItemTemplate>
                    </asp:TemplateField>
                    <asp:TemplateField HeaderText="Quantity">
                    <ItemTemplate>
                    <asp:Label runat="server" ID="lbl2" Text='<%Eval("OPQuantity") %>'></asp:Label>
                    </ItemTemplate>
                    </asp:TemplateField>
                    <asp:TemplateField HeaderText="Price">
                    <ItemTemplate>
                    <asp:Label runat="server" ID="lbl3" Text='<%Eval("PPrice") %>'></asp:Label>
                    </ItemTemplate>
                    </asp:TemplateField>
                    <asp:TemplateField HeaderText="Total">
                    <ItemTemplate>
                    <asp:Label runat="server" ID="lbl4" Text='<%Eval("OPTotalPrice") %>'></asp:Label>
                    </ItemTemplate>
                    </asp:TemplateField>
                    </Columns>
                    </asp:GridView>

code for aspx.cs page:-

C#

SqlDataAdapter daShow1 = new SqlDataAdapter("SELECT a.OID, a.PID, b.PName as PName, a.OPQuantity as OPQuantity, a.PPrice as PPrice, a.OPTotalPrice as OPTotalPrice FROM OrderProducts AS a LEFT OUTER JOIN Products AS b ON a.PID = b.PID WHERE (a.OID = "+txtSearchOrderID.Text+")", con);
        DataSet dsShow1 = new DataSet();
        daShow1.Fill(dsShow1);
        gh1.DataSource = dsShow1;
        gh1.DataBind()

.

Posted 8-Apr-12 0:47am

abhishekagrwl25

Updated 8-Apr-12 1:03am

Mohamed Mitwalli

v3

Add a Solution

Comments

tanweer 8-Apr-12 6:56am

put your exception text here if there occurs error otherwise put a break point on this line
gh1.DataSource = dsShow1;
and select dsShow1 and right click on it --go to Quick Watch and see the table data. It seems your query does not return any result.

abhishekagrwl25 8-Apr-12 10:08am

its not showing any exception, query is right, i have checked it on sql query analyser, dsshow1 has data but it not bind it to gridview.

2 solutions

Solution 2

Try This...

C#

SqlCommand cmd=new SqlCommand("SELECT a.OID, a.PID, b.PName as PName, a.OPQuantity as OPQuantity, a.PPrice as PPrice, a.OPTotalPrice as OPTotalPrice FROM OrderProducts AS a LEFT OUTER JOIN Products AS b ON a.PID = b.PID WHERE (a.OID = "+txtSearchOrderID.Text+")", con);

SqlDataAdapter daShow1 = new SqlDataAdapter(cmd);

SqlCommandBuilder cb = new SqlCommandBuilder(daShow1);
        DataSet dsShow1 = new DataSet();
        daShow1.Fill(dsShow1);
        gh1.DataSource = dsShow1;
        gh1.DataBind();

Posted 8-Apr-12 1:21am

Kuldeep B

Updated 8-Apr-12 8:01am

v2

Comments

abhishekagrwl25 8-Apr-12 10:19am

also tried it...but still having same problem..

Kuldeep B 8-Apr-12 13:09pm

check that your query return result(some row) or it may be not content record...

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)

Mohamed Mitwalli · Accepted Answer · 2012-04-08T01:02:00

Hi ,
i modified the Solution it work fine

C#

SqlConnection con = new SqlConnection(@"Data Source=.;Initial Catalog=TestDB;Integrated Security=True");
        con.Open();
        SqlDataAdapter daShow1 = new SqlDataAdapter("SELECT a.OID, a.PID, b.PName as PName, a.OPQuantity as OPQuantity, a.PPrice as PPrice, a.OPTotalPrice as OPTotalPrice FROM OrderProducts AS a LEFT OUTER JOIN Products AS b ON a.PID = b.PID WHERE (a.OID = '" + txtSearchOrderID.Text + "'", con);

       // SqlDataAdapter daShow1 = new SqlDataAdapter("select * from dbo.Test_Tbl  where Name  = '" + txtSearchOrderID.Text + "'", con);
        DataSet dsShow1 = new DataSet();
        daShow1.Fill(dsShow1);
        gh1.DataSource = dsShow1.Tables[0];
        gh1.DataBind();

ASP.NET

<asp:GridView runat="server" ID="gh1" AutoGenerateColumns="false" EmptyDataText="No">
                    <Columns>
                    <asp:TemplateField HeaderText="Product Name">

                    <ItemTemplate>
                        <asp:Label ID="lbl1" runat="server" Text='<%# Eval("PName") %>'></asp:Label>
                    </ItemTemplate>
                    </asp:TemplateField>
                    <asp:TemplateField HeaderText="Quantity">
                    <ItemTemplate>
                    <asp:Label runat="server" ID="lbl2" Text='<%#Eval("OPQuantity") %>'></asp:Label>
                    </ItemTemplate>
                    </asp:TemplateField>
                    <asp:TemplateField HeaderText="Price">
                    <ItemTemplate>
                    <asp:Label runat="server" ID="lbl3" Text='<%#Eval("PPrice") %>'></asp:Label>
                    </ItemTemplate>
                    </asp:TemplateField>
                    <asp:TemplateField HeaderText="Total">
                    <ItemTemplate>
                    <asp:Label runat="server" ID="lbl4" Text='<%#Eval("OPTotalPrice") %>'></asp:Label>
                    </ItemTemplate>
                    </asp:TemplateField>
                    </Columns>
                    </asp:GridView>

the Problem was
1 - in your sql statement .
2 - in your expression binding , you were binding like this

C#

<asp:Label runat="server" ID="lbl1" Text='<%Eval("PName")%>'></asp:Label>

and you should do it like this one

C#

<asp:Label ID="lbl1" runat="server" Text='<%# Eval("PName") %>'></asp:Label>

Hope it help you .
Best Regards
M.Mitwalli