In my datagrid, I call my SP and if I only have a simple select statement, everything comes back fine and all rows get displayed in datagrid using datasource and databind
But if I use a cursor inside the SP (to manipulate data), the data that comes out of the SP can not be displayed in the datagrid. In this case only the first row shows up
Here is aportion of my page_load
System.Data.Sql Client.SqlComma nd cm;
System.Data.Sql Client.SqlDataR eader dr = null;
System.Data.Sql Client.SqlComma nd cm;
//DataSet ds = new DataSet();
cm = new System.Data.Sql Client.SqlComma nd();
cm.Connection = ConnectionStrin g;
cm.Connection.O pen();
cm.CommandType = System.Data.Com mandType.Stored Procedure;
cm.CommandText = "[getTransList]";
dr = cm.ExecuteReade r();
gridListData.Da taSource=dr;
gridListData.Da taBind();
dr.Close();