如何从两个数据库读取数据到Asp.net应用程序 [英] how to read data from two Database into Asp.net Application

问题描述

我正在研究一个asp.net项目，该项目需要使用两个不同数据库的网格视图绑定数据

我该怎么做?

解决方案

从两个数据库中获取数据，将其放入您可能拥有的单个业务模型对象中，并将其绑定到网格.

如果数据格式相同，则应从数据库中获取数据，然后保存在两个数据表中，然后将这些数据合并到另一个数据表中并绑定gridview.

最好的问候，
Theingi win

1.在Web配置中添加两个连接String
2.在代码页中调用两个连接.
3.so for u将获得两个数据集
4.使用合并功能

现在，您将在单个页面中从不同数据库中获得两个表.

<添加名称= "  connectionstring = "  providername = "  System.Data.OracleClient"/>

< add name = "  connectionstring = " 数据源= ......" providername =  /> 

In coding page

 字符串 conn_user = System.Configuration.ConfigurationManager.ConnectionStrings ["  Constringnew"].ToString();
字符串 conn = System.Configuration.ConfigurationManager.ConnectionStrings [" ].ToString();

 字符串 query_login = " 新 SqlConnection(conn);
        SqlDataAdapter da_login = 新 SqlDataAdapter(query_login，con_login);
        DataSet ds_login = 新 DataSet();
        da_login.Fill(ds_login);

        字符串 query_user = " ;
        SqlConnection con_user = 新 SqlConnection(conn_user);
        SqlDataAdapter da_user = 新 SqlDataAdapter(query_user，con_user);
        DataSet ds_user = 新 DataSet();
        da_user.Fill(ds_user);

        ds_login.Merge(ds_user); 

I am working on a asp.net project which needed to bind data with grid-view from two different database

How can i do this?

解决方案

Get the data from two databases, put that into a single Business model object you might have and bind it to the grid.

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

这篇关于如何从两个数据库读取数据到Asp.net应用程序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！