protected void BindGrid5() { if (!this.IsPostBack) { string constr = ConfigurationManager.ConnectionStrings["WebAppConnString"].ConnectionString; using (MySqlConnection con = new MySqlConnection(constr)) { using (MySqlCommand cmd = new MySqlCommand("SELECT * FROM database.activite WHERE activite.iduser='******' AND activite.nature='Lire et écrire'")) { using (MySqlDataAdapter sda = new MySqlDataAdapter()) { cmd.Connection = con; sda.SelectCommand = cmd; using (DataTable dt = new DataTable()) { sda.Fill(dt); DataGrid5.DataSource = dt; DataGrid5.DataBind(); } } } } } }
protected void Page_Load(object sender, EventArgs e) { //Establish the database connection using (SqlConnection Connect = new SqlConnection("data source=.;database=assignment;integrated security= SSPI")) { SqlDataAdapter SDA = new SqlDataAdapter("Select * from students", Connect); //to retrive the data from database- student created SqlDataAdapter SDA1 = new SqlDataAdapter("Select * from Employee", Connect); //to retrive the data from database- student created SqlDataAdapter SDA2 = new SqlDataAdapter("Select * from CricketTeam", Connect); //to retrive the data from database- student created SqlDataAdapter SDA3 = new SqlDataAdapter("Select * from IRS", Connect); //to retrive the data from database- student created SqlDataAdapter SDA4 = new SqlDataAdapter("Select * from Bank_EmployeeDetails", Connect); //to retrive the data from database- student created DataSet ds = new DataSet(); //to convert the data into the grid. DataSet ds1 = new DataSet(); //to convert the data into the grid. DataSet ds2 = new DataSet(); //to convert the data into the grid. DataSet ds3 = new DataSet(); //to convert the data into the grid. DataSet ds4 = new DataSet(); //to convert the data into the grid. SDA.Fill(ds); SDA1.Fill(ds1); SDA2.Fill(ds2); SDA3.Fill(ds3); SDA4.Fill(ds4); DataGrid1.DataSource = ds; DataGrid1.DataBind(); DataGrid2.DataSource = ds1; DataGrid2.DataBind(); DataGrid3.DataSource = ds2; DataGrid3.DataBind(); DataGrid4.DataSource = ds3; DataGrid4.DataBind(); DataGrid5.DataSource = ds4; DataGrid5.DataBind(); } }
protected void Grid_PageIndexChanged(object source, DataGridPageChangedEventArgs e) { DataGrid5.CurrentPageIndex = e.NewPageIndex; if (!this.IsPostBack) { string constr = ConfigurationManager.ConnectionStrings["WebAppConnString"].ConnectionString; using (MySqlConnection con = new MySqlConnection(constr)) { using (MySqlCommand cmd = new MySqlCommand("SELECT * FROM database.titre WHERE titre.codeuser="******"urole"] + " AND titre.numzone='C31' UNION SELECT * FROM database.detail WHERE detail.codeuser="******"urole"] + " AND detail.numzone='C31' ")) { using (MySqlDataAdapter sda = new MySqlDataAdapter()) { cmd.Connection = con; sda.SelectCommand = cmd; using (DataTable dt = new DataTable()) { sda.Fill(dt); DataGrid5.DataSource = dt; DataGrid5.DataBind(); } } } } } }
protected void Page_Load(object sender, EventArgs e) { using (SqlConnection connect = new SqlConnection("server=DESKTOP-NOQ9PCB\\MSSQLSERVER01;database=DxcTraining; integrated security=true")) { SqlDataAdapter sda = new SqlDataAdapter("select * from student1", connect); DataSet ds = new DataSet(); sda.Fill(ds); DataGrid1.DataSource = ds; DataGrid1.DataBind(); SqlDataAdapter sda1 = new SqlDataAdapter("select * from Employee2", connect); DataSet ds1 = new DataSet(); sda1.Fill(ds1); DataGrid2.DataSource = ds1; DataGrid2.DataBind(); SqlDataAdapter sda2 = new SqlDataAdapter("select * from IndianCricketTeam", connect); DataSet ds2 = new DataSet(); sda2.Fill(ds2); DataGrid3.DataSource = ds2; DataGrid3.DataBind(); SqlDataAdapter sda3 = new SqlDataAdapter("select * from IndianRailwaySystem1 ", connect); DataSet ds3 = new DataSet(); sda3.Fill(ds3); DataGrid4.DataSource = ds3; DataGrid4.DataBind(); SqlDataAdapter sda4 = new SqlDataAdapter("select * from BankTable", connect); DataSet ds4 = new DataSet(); sda4.Fill(ds4); DataGrid5.DataSource = ds4; DataGrid5.DataBind(); } }
protected void BindData() { if (!this.IsPostBack) { string constr = ConfigurationManager.ConnectionStrings["WebAppConnString"].ConnectionString; using (MySqlConnection con = new MySqlConnection(constr)) { using (MySqlCommand cmd = new MySqlCommand("SELECT * FROM database.titre WHERE titre.codeuser='******' AND titre.numzone='C31' UNION SELECT * FROM database.detail WHERE detail.codeuser='******' AND detail.numzone='C31' ")) { using (MySqlDataAdapter sda = new MySqlDataAdapter()) { cmd.Connection = con; sda.SelectCommand = cmd; using (DataTable dt = new DataTable()) { sda.Fill(dt); DataGrid5.DataSource = dt; DataGrid5.DataBind(); } } } } } }