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();
}
}
}
}
}
}
