webconfig配置:

复制代码 代码如下:

<connectionStrings>

  <add name=”MSSQL” connectionString=”Data Source=localhost;Initial Catalog=test;User ID=sa;password=sa;” providerName=”System.Data.SqlClient”/>

</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”>

<html xmlns=”http://www.w3.org/1999/xhtml”>

<head runat=”server”>

    <title>DB</title>

</head>

<body>

    <form id=”form1″ runat=”server”>

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

您可能感兴趣的文章:

  • 从EFCore上下文的使用到深入剖析DI的生命周期最后实现自动属性注入
  • asp.net实现存储和读取数据库图片
  • asp.net上传Excel文件并读取数据的实现方法
  • ASP.NET TreeView读取数据库实例
  • .net EF Core专题：EF Core 读取数据时发生了什么？
声明：本站（华域联盟www.cnhackhy.com）所有文章，如无特殊说明或标注，均为本站原创发布。任何个人或组织，在未征得本站同意时，禁止复制、盗用、采集、发布本站内容到任何网站、书籍等各类媒体平台。如若本站内容侵犯了原著者的合法权益，可联系我们进行处理。