您现在的位置： 万盛学电脑网 >> 程序编程 >> 网络编程 >> asp.net编程 >> 正文
asp.net连接数据库读取数据示例分享
作者：佚名 责任编辑：admin 更新时间：2022-06-22
这篇文章主要介绍了asp.net连接数据库读取数据示例,大家参考使用吧
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; } }- 上一个程序编程： iframe跨域与session失效问题的解决办法
- 下一个程序编程： Asp.net 一般处理程序+扩展
