asp.net连接数据库读取数据示例分享

　　webconfig配置:

　　</connectionStrings>

　　前台aspx:

复制代码代码如下:

　　<%@ Page Language="C#" AutoEventWireup="true" CodeFile="DB.aspx.cs" Inherits="DB" %>

　　<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

　　</head>

　　<body>

　　<div>

　　MS SQL<asp:GridView ID="GridView1" runat="server">

　　</asp:GridView>

　　</div>

　　</form>

　　</body>

　　</html>

　　后台代码：

复制代码代码如下:

　　using System;

　　using System.Collections.Generic;

　　using System.Web;

　　using System.Web.UI;

　　using System.Web.UI.WebControls;

　　using System.Data;

　　using System.Data.Common;//記得要using

　　using System.Configuration;

　　public partial class DB : System.Web.UI.Page

　　{

　　protected void Page_Load(object sender, EventArgs e)

　　{

　　DataSet dsMSSQL = GetDataSet("select * from [Table]", "MSSQL");

　　this.GridView1.DataSource = dsMSSQL;

　　this.GridView1.DataBind();

　　}

　　protected DataSet GetDataSet(string SqlCommand,string DB)

　　{

　　DbProviderFactory dbProviderFactory = DbProviderFactories.GetFactory(ConfigurationManager.ConnectionStrings[DB].ProviderName);

　　DbConnection dbConnection = dbProviderFactory.CreateConnection();

　　dbConnection.ConnectionString = ConfigurationManager.ConnectionStrings[DB].ConnectionString;

　　DataSet ds = new DataSet();

　　DbCommand dbCommand = dbProviderFactory.CreateCommand();

　　dbCommand.Connection = dbConnection;

　　DbDataAdapter dbDataAdapter = dbProviderFactory.CreateDataAdapter();

　　dbCommand.CommandText = SqlCommand;

　　dbDataAdapter.SelectCommand = dbCommand;

　　dbDataAdapter.Fill(ds);

　　return ds;

　　}