Here i am retreiving the data from two database.
HTML
<div>
Northwind database
<asp:GridView ID="gvEmployees" AutoGenerateColumns="false" runat="server">
<Columns>
<asp:BoundField DataField="EmployeeId" HeaderText="Employee Id" />
<asp:BoundField DataField="FirstName" HeaderText="First Name" />
<asp:BoundField DataField="LastName" HeaderText="Last Name" />
</Columns>
</asp:GridView>
<hr />
Student database
<asp:GridView ID="gvStudents" AutoGenerateColumns="false" runat="server">
<Columns>
<asp:BoundField DataField="StudentId" HeaderText="Student Id" />
<asp:BoundField DataField="StudentName" HeaderText="Student Name" />
<asp:BoundField DataField="Status" HeaderText="Status" />
</Columns>
</asp:GridView>
</div>
Namespaces
using System.Data;
using System.Data.Sql;
using System.Data.SqlClient;
C#
protected void Page_Load(object sender, EventArgs e)
{
if (!this.IsPostBack)
{
string constrStudents = ConfigurationManager.ConnectionStrings["Students"].ConnectionString;
string constrNorthwind = ConfigurationManager.ConnectionStrings["Northwind"].ConnectionString;
string employees = "SELECT EmployeeId, FirstName,LastName FROM Employees";
string students = "SELECT * FROM Students";
this.PopulateEmployees(this.gvEmployees, employees, constrNorthwind);
this.PopulateEmployees(this.gvStudents, students, constrStudents);
}
}
private void PopulateEmployees(GridView gv, string query, string constr)
{
using (SqlConnection con = new SqlConnection(constr))
{
using (SqlCommand cmd = new SqlCommand(query, con))
{
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
DataTable dt = new DataTable();
da.Fill(dt);
gv.DataSource = dt;
gv.DataBind();
}
}
}
}
Screenshot
