View Code
代碼如下:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
<center>
<h2><font face="宋體">訪問數據庫的通用代碼實例</font>
</h2>
</center>
<body>
<form id="form1" runat="server">
<div>
<font face="宋體">
<p align="center">1.請輸入相應數據庫連接字符串</p>
<p align="center">
<asp:TextBox id="ConnStrTextBox" runat="server" Width="600"></asp:TextBox>
</p>
<p align="center">2.請輸入相應SQL查詢命令語句</p>
<p align="center">
<asp:TextBox id="SqlTextTextBox" runat="server" Width="600"></asp:TextBox>
</p>
<p align="center">3.請選擇所連接的數據庫類型</p>
<p align="center">
<asp:DropDownList ID="DBDropDownList" runat="server" Width="204px">
<asp:ListItem Selected="True">Access</asp:ListItem>
<asp:ListItem>SQLServer</asp:ListItem>
<asp:ListItem>Oracle</asp:ListItem>
<asp:ListItem>DB2</asp:ListItem>
</asp:DropDownList>
</p>
<p align="center">
<asp:Button ID="Button1" runat="server" onclick="Button1_Click" Text="通用數據庫連接代碼測試" />
</p>
<p align="center">
<asp:Label id="lblMessage" runat="server" Font-Bold="True" ForeColor="Red"></asp:Label>
</p>
</form>
</font>
</div>
asp.net頁面
代碼如下:
using System;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
//通用數據庫連接代碼,這里以連接Access數據庫為測試示例
if (!IsPostBack)
{
ConnStrTextBox.Text = "Provider=Microsoft.Jet.OLEDB.4.0; Data source=" + Server.MapPath("User.mdb");
SqlTextTextBox.Text = "Select COUNT(*) From Info Where Name='小顧'";
lblMessage.Text = "";
}
新聞熱點
疑難解答
圖片精選