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