GridView not displaying data in browser on pressing button Go when bind to DataTable

[weird0]

I have created a GridView and dynamically added data to it by
creating a DataTable(as advised) and bound it with a reader. Then,
assigned the DataSource of GridView to DataTable. But even that aint
working as alternatively
assigned reader obj. to datasource of GridView. Here is the code for
the aspx.cs page: ( The reader surely cootains data as its HasRows
property is true). Plz help. Never got stuck this bad with a problem.
For more than two weeks.

protected void Button1_Click(o bject sender, EventArgs e)
{
// CustID->AccId->ATM-Id->Atm_TransID... .
int AtmtransId=-1;
if (Session["CustomerId "]!=null)

AtmtransId=Data AccessLayer.ATM Manager.getATMT ransactionsID(S ession["CustomerId "].ToString(),Acc NamesList.Selec tedItem.Text);
string Query = "SELECT atmtrans_date AS Date,atmtrans_b ranch
AS Branch,atmtrans _type AS Type,atmtrans_a mount AS Amount FROM
ATM_Transaction s WHERE atmtrans_id=@AT MTRANSID";
SqlConnection sqlconnection = new SqlConnection(@ "Data Source=.
\SQLEXPRESS;Att achDbFilename=| DataDirectory|\ BankingDb.mdf;I ntegrated
Security=True;U ser Instance=True") ;
SqlCommand cmd = new SqlCommand(Quer y,sqlconnection );
cmd.Parameters. AddWithValue("@ ATMTRANSID",Atm transId);
GridView GridView1 = new GridView();
sqlconnection.O pen();
// Fill the Data Reader
SqlDataReader reader=cmd.Exec uteReader();
//Create a DataTable object
DataTable dt=new DataTable();
//Load Data from Data Reader to DataTable object
dt.Load(reader) ;
//Fill the GridView Control
GridView1.DataS ource = dt;
GridView1.DataB ind();
reader.Close();
sqlconnection.C lose();
}

[=?Utf-8?B?UGV0ZXIgQnJvbWJlcmcgW0MjIE1WUF0=?=]

Couple suggestions:
1) Try the ASP.NET group, this is really not a C# language group question.
2) Get in the habit of wiring up any code you write that could *possibly*
cause an exception into a try / catch / finally block pattern.

When you do this, for debugging purposes you can do things like:

System.Diagnost ics.Debug.Write Line( ex.Message +ex.StackTrace) ;

on the "ex" Exception object inside the catch block and get a lot of very
useful information about what went wrong.

Peter

--
Site: http://www.eggheadcafe.com
UnBlog: http://petesbloggerama.blogspot.com
Short urls & more: http://ittyurl.net


"weird0" wrote:

I have created a GridView and dynamically added data to it by
creating a DataTable(as advised) and bound it with a reader. Then,
assigned the DataSource of GridView to DataTable. But even that aint
working as alternatively
assigned reader obj. to datasource of GridView. Here is the code for
the aspx.cs page: ( The reader surely cootains data as its HasRows
property is true). Plz help. Never got stuck this bad with a problem.
For more than two weeks.

protected void Button1_Click(o bject sender, EventArgs e)
{
// CustID->AccId->ATM-Id->Atm_TransID... .
int AtmtransId=-1;
if (Session["CustomerId "]!=null)

AtmtransId=Data AccessLayer.ATM Manager.getATMT ransactionsID(S ession["CustomerId "].ToString(),Acc NamesList.Selec tedItem.Text);
string Query = "SELECT atmtrans_date AS Date,atmtrans_b ranch
AS Branch,atmtrans _type AS Type,atmtrans_a mount AS Amount FROM
ATM_Transaction s WHERE atmtrans_id=@AT MTRANSID";
SqlConnection sqlconnection = new SqlConnection(@ "Data Source=.
\SQLEXPRESS;Att achDbFilename=| DataDirectory|\ BankingDb.mdf;I ntegrated
Security=True;U ser Instance=True") ;
SqlCommand cmd = new SqlCommand(Quer y,sqlconnection );
cmd.Parameters. AddWithValue("@ ATMTRANSID",Atm transId);
GridView GridView1 = new GridView();
sqlconnection.O pen();
// Fill the Data Reader
SqlDataReader reader=cmd.Exec uteReader();
//Create a DataTable object
DataTable dt=new DataTable();
//Load Data from Data Reader to DataTable object
dt.Load(reader) ;
//Fill the GridView Control
GridView1.DataS ource = dt;
GridView1.DataB ind();
reader.Close();
sqlconnection.C lose();
}