how to read data from two Database into Asp.net Application

If your data are the same format you should take data from your databases and then kept in two data tables.After that combine these data in another datatable and bind gridview.

Best regard,
Theingi win

1.Add two connection String in web config
2.Call two connection in code page.
3.so for u will get two dataset
4.Use Merge function

Now u will get the two table from different database in a single page.

<add name="Constring" connectionstring="Data Source=......" providername="System.Data.OracleClient" />

<add name="Constringnew" connectionstring="Data Source=......" providername="System.Data.OracleClient" />

In coding page

String conn_user= System.Configuration.ConfigurationManager.ConnectionStrings["Constringnew"].ToString();
String conn = System.Configuration.ConfigurationManager.ConnectionStrings["Constring"].ToString();

string query_login = "select * from Login";
        SqlConnection con_login = new SqlConnection(conn);
        SqlDataAdapter da_login = new SqlDataAdapter(query_login, con_login);
        DataSet ds_login = new DataSet();
        da_login.Fill(ds_login);

        string query_user= "select * from tbl_user";
        SqlConnection con_user = new SqlConnection(conn_user);
        SqlDataAdapter da_user = new SqlDataAdapter(query_user, con_user);
        DataSet ds_user = new DataSet();
        da_user.Fill(ds_user);

        ds_login.Merge(ds_user);

use linked server.. after linking the server, you can access them as in one database... follow the link to know more

http://msdn.microsoft.com/en-us/library/aa213778(v=sql.80).aspx[^]

http://msdn.microsoft.com/en-us/library/ms188279.aspx[^]