Show cart details on a button click event

Question

I want to show my cart details on a Button_Click_Event. I'm using a Gridview control of ASP.NET framework. But the following exception occurs:

object reference is not set to a instance of an object.

How can I fix it? Here is my code:

protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
    string st = "select * FROM cart_master";
    cmd = new SqlCommand(st, sqlcon);
    cmd.Connection.Open();
    cmd.ExecuteNonQuery();
    SqlDataAdapter sda = new SqlDataAdapter(cmd);
    DataSet ds = new DataSet();
    GridView GridView1 = (GridView)ContentPlaceHolder1.FindControl("GridView1");
    sda.Fill(ds, "cart_master");
    GridView1.DataSource = ds.Tables["cart_master"];
    GridView1.DataBind();
    cmd.Connection.Close();
}

GridView1.DataSource = ds.Tables["cart_master"]; line throws a exception @Pleun — Anurag Dixit, Sep 06 '14 at 08:53
I'm just going to say two things here, bad Architecture, bad Security. — Callum Linington, Sep 06 '14 at 09:25
I think the error doesn't come from the data source but from the GridView side. `GridView1` is possible null and it is beacause the `FindControl` method call doesn't find the GridView. Please post your markup code — luviktor, Sep 06 '14 at 10:32
@AnuragDixit I understand you! Sometimes you gotta do what you gotta do. I just feel sorry for the poor fellow who has to use this. — Callum Linington, Sep 09 '14 at 10:59

score 0 · Answer 1 · answered Sep 06 '14 at 09:20

0

Rather than dataset, just fill a datatable from your adapter

DataTable dataTable = new DataTable("ResultDataTable");
sda.Fill( dataTable);
GridView1.DataSource = dataTable;

answered Sep 06 '14 at 09:20

Pankaj

2,618
3
25
47

Show cart details on a button click event

1 Answers1