using System;
2using System.Data;
3using System.Configuration;
4using System.Collections;
5using System.Web;
6using System.Web.Security;
7using System.Web.UI;
8using System.Web.UI.WebControls;
9using System.Web.UI.WebControls.WebParts;
10using System.Web.UI.HtmlControls;
11using System.Data.SqlClient; //added by zhangq
13public partial class TestDB : System.Web.UI.Page
14{
private void ReadSingleResult()
{
//创建数据连接
//从文件web.config中读取数据库链接字符串
string conString = ConfigurationManager.ConnectionStrings["DBTESTConnectionString"].ConnectionString;
SqlConnection myCon = new SqlConnection(conString);
22 //创建执行命令
SqlCommand myCmd = new SqlCommand("SELECT TOP 3 * FROM 仓库 ORDER BY 仓库号 DESC", myCon);
25 //定义dr
SqlDataReader dr = null;
try
{
myCon.Open(); //打开数据库的链接
dr = myCmd.ExecuteReader();
ShowData(dr);
dr.Close();
}
catch (Exception ex) { Response.Write(ex.Message); }
finally
{
myCon.Close();
}
}
private void ShowData(SqlDataReader dr)
{
String str = "";
for (int i = 0; i < dr.FieldCount; i++)
{
str = str + dr.GetName(i);
}
str = str + "<br>";
while (dr.Read())
{
for (int i = 0; i < dr.FieldCount; i++)
{
str = str + dr[i].ToString();
}
}
Response.Write(str);
}
protected void Page_Load(object sender, EventArgs e)
{
ReadSingleResult();
}
61}
2using System.Data;
3using System.Configuration;
4using System.Collections;
5using System.Web;
6using System.Web.Security;
7using System.Web.UI;
8using System.Web.UI.WebControls;
9using System.Web.UI.WebControls.WebParts;
10using System.Web.UI.HtmlControls;
11using System.Data.SqlClient; //added by zhangq
13public partial class TestDB : System.Web.UI.Page
14{
private void ReadSingleResult()
{
//创建数据连接
//从文件web.config中读取数据库链接字符串
string conString = ConfigurationManager.ConnectionStrings["DBTESTConnectionString"].ConnectionString;
SqlConnection myCon = new SqlConnection(conString);
22 //创建执行命令
SqlCommand myCmd = new SqlCommand("SELECT TOP 3 * FROM 仓库 ORDER BY 仓库号 DESC", myCon);
25 //定义dr
SqlDataReader dr = null;
try
{
myCon.Open(); //打开数据库的链接
dr = myCmd.ExecuteReader();
ShowData(dr);
dr.Close();
}
catch (Exception ex) { Response.Write(ex.Message); }
finally
{
myCon.Close();
}
}
private void ShowData(SqlDataReader dr)
{
String str = "";
for (int i = 0; i < dr.FieldCount; i++)
{
str = str + dr.GetName(i);
}
str = str + "<br>";
while (dr.Read())
{
for (int i = 0; i < dr.FieldCount; i++)
{
str = str + dr[i].ToString();
}
}
Response.Write(str);
}
protected void Page_Load(object sender, EventArgs e)
{
ReadSingleResult();
}
61}