Data not displayed in Gridview

Question

0.00/5 (No votes)

See more:

Hi I am just trying a simple program . Trying to fetch the details from DB and binding it to the gridview.When I type text in text box its not displaying anything

C#

protected void Button1_Click(object sender, EventArgs e)
        {
            string CS = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;
            using(SqlConnection con= new SqlConnection(CS))
            {
                string command = "select * from tblProductInventory where ProductName like ' " + TextBox1.Text + "%'";
                
                SqlCommand cmd = new SqlCommand(command,con);
                con.Open();
                GridView1.DataSource = cmd.ExecuteReader();
                GridView1.DataBind();

            }

design page

C#

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm1.aspx.cs" Inherits="SqlInjection.WebForm1" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>    
        <asp:Button ID="Button1" runat="server" Text="Get Products" 
            onclick="Button1_Click" />
        <asp:GridView ID="GridView1" runat="server" BackColor="#DEBA84" 
            BorderColor="#DEBA84" BorderStyle="None" BorderWidth="1px" CellPadding="3" 
            CellSpacing="2">
            <FooterStyle BackColor="#F7DFB5" ForeColor="#8C4510" />
            <HeaderStyle BackColor="#A55129" Font-Bold="True" ForeColor="White" />
            <PagerStyle ForeColor="#8C4510" HorizontalAlign="Center" />
            <RowStyle BackColor="#FFF7E7" ForeColor="#8C4510" />
            <SelectedRowStyle BackColor="#738A9C" Font-Bold="True" ForeColor="White" />
            <SortedAscendingCellStyle BackColor="#FFF1D4" />
            <SortedAscendingHeaderStyle BackColor="#B95C30" />
            <SortedDescendingCellStyle BackColor="#F1E5CE" />
            <SortedDescendingHeaderStyle BackColor="#93451F" />
        </asp:GridView>
    </div>
    </form>
</body>
</html>

Mydatabase has
ID ProductName QuantityAvailable
101 Iphone 101
105 iPads 134

Posted 8-Sep-14 3:46am

ShaHam11

Updated 8-Sep-14 3:52am

v4

Add a Solution

1 solution

Add a Solution

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

abhipriy · Answer 1 · 2014-09-08T04:19:00

Solution 1

First Define Datatable then fill the same datatable.
Code
DataTable dt =new DataTable();
SqlCommand cmd = new SqlCommand(command,con);
con.Open();
SqlDataAdapter sda = new SqlDataAdapter(cmd);
sda.Fill(dt);
GridView1.DataSource = dt;
GridView1.DataBind();

Posted 8-Sep-14 4:19am

abhipriy

Data not displayed in Gridview

1 solution

Solution 1

Add your solution here

Preview 0

Data not displayed in Gridview

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us