Dynamically binding data to a gridview.
Posted on 2007-04-03
We are using Model View Controller Framework in our ASP.net Application developed in C#,MS SQL Server.
For Eg. in one of my ASPX page I am binding data to the grid as shown below:
protected void LoadTasks()
lstTaskLst.ListDataSource = TaskController.GetAllTasks(true,CurrentUser);
Here is the code in my Controller:
public static List<Task> GetAllTasks(bool active,UserInfo assignedTo)
return TaskDAL.SelectAllToUser(active, assignedTo.UserID);
Here is code from my DAL:
public static List<Task> SelectAllToUser(bool? active, int assigned_to)
List<Task> tasks = new List<Task>();
Task currenttask = null;
GenericDatabase db = new GenericDatabase(z360.Configuration.CurrentConceptConnectionString(), );
DbCommand dbCommand = db.GetStoredProcCommand("Calendar_Task_sel_only_By_User");
if (active == null)
db.AddInParameter(dbCommand, "active", DbType.String, DBNull.Value);
db.AddInParameter(dbCommand, "active", DbType.String, active);
db.AddInParameter(dbCommand, "assigned_to", DbType.Int32, assigned_to);
dbReader = db.ExecuteReader(dbCommand);
currenttask = LoadFromDataReader(dbReader);
if (currenttask != null)
if (tasks.Count == 0)
tasks = null;
And in LoadFromDataReader I am reading all the data from the datareader
It is working absolutely fine. But I have some other issue now. Now instead of binding data from the Stored Procedure which is currently returning a list, is there a way I can bind it to a SQL Statement. The reason is I have a wizard control where users will pick whatever columns they want.
Appreciate if you could throw some light on this.