Sunday, 9 August 2015

Using Variable in Lambda expression


public partial class GridPage : System.Web.UI.Page
{

    SqlConnection cn = new SqlConnection("data source=SRIKANTA-PC\\SQLEXPRESS;initial catalog=adi;user id=sa;password=banka");

    protected void Page_Load(object sender, EventArgs e)
    {
     
        if(ConnectionState.Closed == cn.State)
        {
            cn.Open();
        }

 string fname= "n.FirstName";
        lstStudent = (from n in lstStudent orderby n.FirstName descending select n).ToList();


        //string strFName = "FirstName";
        //SqlDataAdapter da = new SqlDataAdapter("select * from student order by " + strFName, cn);

        SqlCommand cmd = new SqlCommand("Select * from student", cn);
        SqlDataReader dr = cmd.ExecuteReader();

        List<student> lstStudent = new List<student>();
        while (dr.Read())
        {
            student oStud = new student();
            oStud.StudentID = int.Parse(dr[0].ToString());
            oStud.FirstName = dr[1].ToString();
            oStud.LastName = dr[2].ToString();

            lstStudent.Add(oStud);
        }


        lstStudent = lstStudent.OrderBy(x =>  x.FirstName).ToList();

        //SqlDataAdapter da = new SqlDataAdapter("select * from student", cn);
        //DataTable dt = new DataTable();
        //da.Fill(dt);

        GridView1.DataSource = lstStudent;
        GridView1.DataBind();

     

    

No comments:

Post a Comment