This code shows sample use of generic
code behind
BusinessClass Obj = new BusinessClass();
List people = new List(); //people = new BusinessClass().LoadThroughDataTable(); people = Obj.LoadThroughDataTable(); grdStatus.DataSource = people; grdStatus.DataBind();
class file
public string event_id { get; set; } public string date_start { get; set; } public string event_name { get; set; } public string location_url { get; set; } public int event_id1 { get; set; } public DateTime date_start1 { get; set; } public string event_name1 { get; set; } public string location_url1 { get; set; }
public List LoadThroughDataTable() { var list = new List(); using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["CONSTR"].ConnectionString)) { using (SqlCommand cmd = new SqlCommand("select event_id,date_start,event_name,location_url from events", conn)) { using (SqlDataAdapter ad = new SqlDataAdapter(cmd)) { DataTable table = new DataTable(); conn.Open(); // open the connection ad.Fill(table); conn.Close(); // close the connection // loop through all rows foreach (DataRow row in table.Rows) {
BusinessClass p = new BusinessClass() { event_id = row["event_id"].ToString(), date_start = row["date_start"].ToString(), event_name = row["event_name"].ToString(), location_url = row["location_url"].ToString()
}; list.Add(p); } } } return list; } }
For more details, visit http://www.dotnetfunda.com/articles/article472-passing-data-between-layers-using-generic-list-collection.aspx
|
No responses found. Be the first to respond and make money from revenue sharing program.
|