Esempio n. 1
0
        protected void Btn_Search_Click(object sender, EventArgs e)
        {
            DataSet dataSet = (DataSet)Session["DATASET"];

            if (string.IsNullOrEmpty(Txt_Input.Text))
            {
                Gvw_Display.DataSource = from dataRow in dataSet.Tables["Students"].AsEnumerable()
                                         select new Student
                {
                    Id         = Convert.ToInt32(dataRow["Id"]),
                    Name       = dataRow["Name"].ToString(),
                    Gender     = dataRow["Gender"].ToString(),
                    TotalMarks = Convert.ToInt32(dataRow["TotalMarks"])
                };
                Gvw_Display.DataBind();
            }
            else
            {
                Gvw_Display.DataSource = from dataRow in dataSet.Tables["Students"].AsEnumerable()
                                         where dataRow["Name"].ToString().ToUpper().Contains(Txt_Input.Text.ToUpper())
                                         select new Student
                {
                    Id         = Convert.ToInt32(dataRow["Id"]),
                    Name       = dataRow["Name"].ToString(),
                    Gender     = dataRow["Gender"].ToString(),
                    TotalMarks = Convert.ToInt32(dataRow["TotalMarks"])
                };
                Gvw_Display.DataBind();
            }
        }
Esempio n. 2
0
        protected void Btn_Search_Click(object sender, EventArgs e)
        {
            StudentDataSet.StudentsDataTable sdt = (StudentDataSet.StudentsDataTable)Session["DATATABLE"];

            if (string.IsNullOrEmpty(Txt_Input.Text))
            {
                Gvw_Display.DataSource = from student in sdt
                                         select new
                {
                    student.Id,
                    student.Name,
                    student.Gender,
                    student.TotalMarks
                };
                Gvw_Display.DataBind();
            }
            else
            {
                Gvw_Display.DataSource = from student in sdt
                                         where student.Name.ToUpper().Contains(Txt_Input.Text.ToUpper())
                                         select new
                {
                    student.Id,
                    student.Name,
                    student.Gender,
                    student.TotalMarks
                };
                Gvw_Display.DataBind();
            }
        }
Esempio n. 3
0
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                StudentDataSetTableAdapters.StudentsTableAdapter sta = new StudentDataSetTableAdapters.StudentsTableAdapter();
                StudentDataSet.StudentsDataTable sdt = new StudentDataSet.StudentsDataTable();
                sta.Fill(sdt);

                Session["DATATABLE"] = sdt;


                Gvw_Display.DataSource = from student in sdt
                                         select new
                {
                    student.Id,
                    student.Name,
                    student.Gender,
                    student.TotalMarks
                };
                Gvw_Display.DataBind();
            }
        }
Esempio n. 4
0
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                string         connectionString = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;
                SqlConnection  con         = new SqlConnection(connectionString);
                string         selectQuery = "SELECT * FROM Students";
                SqlDataAdapter da          = new SqlDataAdapter(selectQuery, con);

                DataSet dataSet = new DataSet();
                da.Fill(dataSet, "Students");
                Session["DATASET"] = dataSet;

                Gvw_Display.DataSource = from dataRow in dataSet.Tables["Students"].AsEnumerable()
                                         select new Student {
                    Id         = Convert.ToInt32(dataRow["Id"]),
                    Name       = dataRow["Name"].ToString(),
                    Gender     = dataRow["Gender"].ToString(),
                    TotalMarks = Convert.ToInt32(dataRow["TotalMarks"])
                };
                Gvw_Display.DataBind();
            }
        }