using System.Data;
using System.Data.SqlClient; // using System.Data.OleDb;下文中的Sql变为OleDb
public partial class Default2 : System.Web.UI.Page
{
protected void Page_Load( object sender, EventArgs e)
{
myDataReader();
myDataSet();
count();
}
public void myDataReader()
{ // 利用DataReader阅读类,执行数据的“只向前”的读取
// "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("App_Data/access.mdb")
string strConn = " Data Source=aidd2008;Initial Catalog=i05;Integrated Security=SSPI; " ;
SqlConnection ConnAcc = new SqlConnection(strConn); // Sql链接类的实例化
ConnAcc.Open(); // 打开数据库
string strSQL = " SELECT * FROM sc order by cno desc " ; // SQL语句
SqlCommand cmd = new SqlCommand(strSQL, ConnAcc); // 创建Command命令对象
SqlDataReader dr = cmd.ExecuteReader(); // 创建DataReader对象,并调用ExecuteReader从数据源检索行
while (dr.Read()) // 启动阅读器的Read方法,返回行的每一列
{
Label1.Text += " + " + dr[ " sno " ]; // 数据读取
}
dr.Close(); // 关闭阅读器
ConnAcc.Close(); // 关闭数据库
}
public void myDataSet()
{ // 利用DataSet,DataAdapter读取数据
string strConn = " Data Source=localhost;Initial Catalog=i05;Integrated Security=SSPI; " ;
SqlConnection ConnAcc = new SqlConnection(strConn); // Sql链接类的实例化
ConnAcc.Open(); // 打开数据库
string strSQL = " SELECT * FROM student order by sno desc " ; // 要执行的SQL语句
SqlDataAdapter da = new SqlDataAdapter(strSQL, ConnAcc); // 创建DataAdapter数据适配器实例
DataSet ds = new DataSet(); // 创建DataSet实例
da.Fill(ds, " 112233 " ); // 使用DataAdapter的Fill方法(填充),调用SELECT命令
GridView1.DataSource = ds.Tables["112233"].DefaultView; // 设置数据源
GridView1.DataBind(); // 绑定数据
ConnAcc.Close(); // 关闭数据库
}
public void Button1_Click( object sender, EventArgs e)
{ // 插入、更新、删除
string strConn = " Data Source=localhost;Initial Catalog=i05;Integrated Security=SSPI; " ;
SqlConnection ConnAcc = new SqlConnection(strConn); // Sql链接类的实例化
ConnAcc.Open(); // 打开数据库
// string strID = System.Guid.NewGuid().ToString();
// string strTime = System.DateTime.Now.ToString();
string strSQL = " INSERT INTO student(sno,sname) values (' " + TextBox1.Text + " ',' " + TextBox2.Text + " ') " ;
// INSERT INTO table1、UPDATE table1 SET、DELETE FROM table1
SqlCommand cmd = new SqlCommand(strSQL, ConnAcc); // 创建Command命令对象
cmd.ExecuteNonQuery(); // 执行命令
ConnAcc.Close(); // 关闭数据库
}
public void count()
{ // 统计:求和、总行数
string strConn = " Data Source=localhost;Initial Catalog=i05;Integrated Security=SSPI; " ;
SqlConnection ConnAcc = new SqlConnection(strConn); // Sql链接类的实例化
ConnAcc.Open(); // 打开数据库
string strSQL = " SELECT COUNT(*) FROM student " ; // SQL统计,SUM等等
SqlCommand cmd = new SqlCommand(strSQL, ConnAcc); // 创建Command命令对象
int intNum = ( int )cmd.ExecuteScalar(); // 得到统计数,SUM则用double
Label2.Text = intNum.ToString();
ConnAcc.Close(); // 关闭数据库
}
protected void GridView1_PageIndexChanging( object sender, System.Web.UI.WebControls.GridViewPageEventArgs e)
{
GridView1.PageIndex = e.NewPageIndex;
GridView1.DataBind();
}
}
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default2.aspx.cs" Inherits="Default2" %>
<!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></title>
</head>
<body>
<form id="form1" runat="server">
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" AllowPaging="True" onpageindexchanging="GridView1_PageIndexChanging" PageSize="2" ShowHeader="False">
<PagerSettings PageButtonCount="2" FirstPageText="first" Mode="NumericFirstLast" />
<Columns>
<asp:TemplateField>
<ItemTemplate>
<%#DataBinder.Eval(Container.DataItem,"sno")%><%#DataBinder.Eval(Container.DataItem,"sname")%>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
...