public List<EventDetails> GetEventDetails() { List<EventDetails> lstEvents = new List<EventDetails>(); SqlConnection conn = new SqlConnection("Data Source=.; Database=Practice; Integrated Security=true;"); string query = "select * from EventDetails"; SqlDataAdapter da = new SqlDataAdapter(query, conn); try { conn.Open(); DataSet ds = new DataSet(); da.Fill(ds); DataTable dt = ds.Tables[0]; List<DataRow> list = new List<DataRow>(dt.Select()); var myEnumerable = dt.AsEnumerable(); lstEvents = (from item in myEnumerable select new EventDetails { Date = item.Field<DateTime>("Date"), Title = item.Field<string>("Title"), PostedBy = item.Field<string>("PostedBy"), Category = item.Field<string>("Category"), Discription = item.Field<string>("Discription") }).ToList(); conn.Close(); return lstEvents; } catch (Exception ex) { throw ex; } }
protected void Page_Load(object sender, EventArgs e) { ServiceEvent.CrudWebServiceSoapClient service = new ServiceEvent.CrudWebServiceSoapClient(); List<EventDetails> lstEvents; lstEvents= service.GetEventDetails(); }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)