斯嘉丽杀人狂原型:asp.net连接数据库实例代码
来源:百度文库 编辑:偶看新闻 时间:2024/10/02 17:55:13
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;
using System.Data.SqlClient;public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{ }
protected void btnConn_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection();
conn.ConnectionString = "Data Source=PC-2009092011513\\SQLEXPRESS;Initial Catalog=Northwind;User ID=sa;Password=123456";
conn.Open();
lblResult.Text = "数据库连接成功!";
//关闭数据库的链接
conn.Close();
//释放资源
conn.Dispose();
}
protected void btnComm_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection();
conn.ConnectionString = "Data Source=PC-2009092011513\\SQLEXPRESS;Initial Catalog=Northwind;User ID=sa;Password=123456";
conn.Open();
SqlCommand comm = new SqlCommand();
comm.CommandText = "select * from Employees";
comm.Connection = conn;
SqlDataReader data;
data = comm.ExecuteReader();
lblCmdResult.Text = "命令执行完毕!";
conn.Close();
conn.Dispose();
}
protected void btnRuselt_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection();
conn.ConnectionString = "Data Source=PC-2009092011513\\SQLEXPRESS;Initial Catalog=Northwind;User ID=sa;Password=123456";
conn.Open();
SqlCommand comm = new SqlCommand();
comm.CommandText = "select EmployeeID as 员工编号,LastName+' '+FirstName as 姓名,Title as 职务,Address as 地址,City as 城市 from Employees";
comm.Connection = conn;
SqlDataReader data = comm.ExecuteReader();
Response.Write("");
");
lblDisplayResult.Text = "数据显示完毕!";
data.Close();
conn.Close();
conn.Dispose();
}
protected void btnPara_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection();
conn.ConnectionString = "Data Source=PC-2009092011513\\SQLEXPRESS;Initial Catalog=Northwind;User ID=sa;Password=123456";
conn.Open();
SqlCommand comm = new SqlCommand();
comm.CommandText = "select EmployeeID as 员工编号,LastName+' '+FirstName as 姓名,Title as 职务,Address as 地址,City as 城市 from Employees where City=@city";
SqlParameter parmCity = new SqlParameter("@city", SqlDbType.NVarChar, 15);
parmCity.Value = txtCity.Text;
comm.Parameters.Add(parmCity);
comm.Connection = conn;
SqlDataReader data = comm.ExecuteReader();
Response.Write("");
");
lblDisplayResult.Text = "数据显示完毕!";
data.Close();
conn.Close();
conn.Dispose();
}
protected void btnProc_Click(object sender, EventArgs e)
{
/*
存储过程的创建
create procedure GetEmployeesByCity
@city nvarchar(15)=null
as
select EmployeeID as 员工编号,LastName +' '+ FirstName as 姓名,
Title as 职务,Address as 地址,City as 城市 from Employees where City=@city
*/ SqlConnection conn = new SqlConnection();
conn.ConnectionString = "Data Source=PC-2009092011513\\SQLEXPRESS;Initial Catalog=Northwind;User ID=sa;Password=123456";
conn.Open();
SqlCommand comm = new SqlCommand();
comm.CommandType = CommandType.StoredProcedure;
comm.CommandText = "GetEmployeesByCity";
SqlParameter parmCity = new SqlParameter("@city", SqlDbType.NVarChar, 15);
parmCity.Direction = ParameterDirection.Input; //输入参数
parmCity.Value = txtProc.Text;
comm.Parameters.Add(parmCity);
comm.Connection = conn;
SqlDataReader data = comm.ExecuteReader();
Response.Write("");
");
lblDisplayResult.Text = "数据显示完毕!";
data.Close();
conn.Close();
conn.Dispose();
}
protected void btnData_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection();
conn.ConnectionString = "Data Source=PC-2009092011513\\SQLEXPRESS;Initial Catalog=Northwind;User ID=sa;Password=123456";
conn.Open();
SqlCommand comm = new SqlCommand();
comm.CommandText = "update Employees set Country='UK' where Country='英国'";
comm.Connection = conn;
int rows = comm.ExecuteNonQuery();
lblData.Text = rows.ToString();
conn.Close();
conn.Dispose();
}
protected void btnSingeResult_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection();
conn.ConnectionString = "Data Source=PC-2009092011513\\SQLEXPRESS;Initial Catalog=Northwind;User ID=sa;Password=123456";
conn.Open();
SqlCommand comm = new SqlCommand();
comm.CommandText = "select AVG(UnitPrice) from Products as 平均价格 where SupplierID=(select SupplierID from Suppliers where CompanyName='Ma Maison')";
comm.Connection = conn;
float avgPrice = float.Parse(comm.ExecuteScalar().ToString());
lblSingeResult.Text = avgPrice.ToString();
conn.Close();
conn.Dispose();
}
}
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;
using System.Data.SqlClient;public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{ }
protected void btnConn_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection();
conn.ConnectionString = "Data Source=PC-2009092011513\\SQLEXPRESS;Initial Catalog=Northwind;User ID=sa;Password=123456";
conn.Open();
lblResult.Text = "数据库连接成功!";
//关闭数据库的链接
conn.Close();
//释放资源
conn.Dispose();
}
protected void btnComm_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection();
conn.ConnectionString = "Data Source=PC-2009092011513\\SQLEXPRESS;Initial Catalog=Northwind;User ID=sa;Password=123456";
conn.Open();
SqlCommand comm = new SqlCommand();
comm.CommandText = "select * from Employees";
comm.Connection = conn;
SqlDataReader data;
data = comm.ExecuteReader();
lblCmdResult.Text = "命令执行完毕!";
conn.Close();
conn.Dispose();
}
protected void btnRuselt_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection();
conn.ConnectionString = "Data Source=PC-2009092011513\\SQLEXPRESS;Initial Catalog=Northwind;User ID=sa;Password=123456";
conn.Open();
SqlCommand comm = new SqlCommand();
comm.CommandText = "select EmployeeID as 员工编号,LastName+' '+FirstName as 姓名,Title as 职务,Address as 地址,City as 城市 from Employees";
comm.Connection = conn;
SqlDataReader data = comm.ExecuteReader();
Response.Write("
"); Response.Write("员工编号"); Response.Write(" | ");"); Response.Write("姓名"); Response.Write(" | ");"); Response.Write("职务"); Response.Write(" | ");"); Response.Write("地址"); Response.Write(" | ");"); Response.Write("城市"); Response.Write(" | ");
"); Response.Write(data.GetValue(0).ToString()); Response.Write(" | ");"); Response.Write(data.GetValue(1).ToString()); Response.Write(" | ");"); Response.Write(data.GetValue(2).ToString()); Response.Write(" | ");"); Response.Write(data.GetValue(3).ToString()); Response.Write(" | ");"); Response.Write(data.GetValue(4).ToString()); Response.Write(" | ");
lblDisplayResult.Text = "数据显示完毕!";
data.Close();
conn.Close();
conn.Dispose();
}
protected void btnPara_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection();
conn.ConnectionString = "Data Source=PC-2009092011513\\SQLEXPRESS;Initial Catalog=Northwind;User ID=sa;Password=123456";
conn.Open();
SqlCommand comm = new SqlCommand();
comm.CommandText = "select EmployeeID as 员工编号,LastName+' '+FirstName as 姓名,Title as 职务,Address as 地址,City as 城市 from Employees where City=@city";
SqlParameter parmCity = new SqlParameter("@city", SqlDbType.NVarChar, 15);
parmCity.Value = txtCity.Text;
comm.Parameters.Add(parmCity);
comm.Connection = conn;
SqlDataReader data = comm.ExecuteReader();
Response.Write("
"); Response.Write("员工编号"); Response.Write(" | ");"); Response.Write("姓名"); Response.Write(" | ");"); Response.Write("职务"); Response.Write(" | ");"); Response.Write("地址"); Response.Write(" | ");"); Response.Write("城市"); Response.Write(" | ");
"); Response.Write(data.GetValue(0).ToString()); Response.Write(" | ");"); Response.Write(data.GetValue(1).ToString()); Response.Write(" | ");"); Response.Write(data.GetValue(2).ToString()); Response.Write(" | ");"); Response.Write(data.GetValue(3).ToString()); Response.Write(" | ");"); Response.Write(data.GetValue(4).ToString()); Response.Write(" | ");
lblDisplayResult.Text = "数据显示完毕!";
data.Close();
conn.Close();
conn.Dispose();
}
protected void btnProc_Click(object sender, EventArgs e)
{
/*
存储过程的创建
create procedure GetEmployeesByCity
@city nvarchar(15)=null
as
select EmployeeID as 员工编号,LastName +' '+ FirstName as 姓名,
Title as 职务,Address as 地址,City as 城市 from Employees where City=@city
*/ SqlConnection conn = new SqlConnection();
conn.ConnectionString = "Data Source=PC-2009092011513\\SQLEXPRESS;Initial Catalog=Northwind;User ID=sa;Password=123456";
conn.Open();
SqlCommand comm = new SqlCommand();
comm.CommandType = CommandType.StoredProcedure;
comm.CommandText = "GetEmployeesByCity";
SqlParameter parmCity = new SqlParameter("@city", SqlDbType.NVarChar, 15);
parmCity.Direction = ParameterDirection.Input; //输入参数
parmCity.Value = txtProc.Text;
comm.Parameters.Add(parmCity);
comm.Connection = conn;
SqlDataReader data = comm.ExecuteReader();
Response.Write("
"); Response.Write("员工编号"); Response.Write(" | ");"); Response.Write("姓名"); Response.Write(" | ");"); Response.Write("职务"); Response.Write(" | ");"); Response.Write("地址"); Response.Write(" | ");"); Response.Write("城市"); Response.Write(" | ");
"); Response.Write(data.GetValue(0).ToString()); Response.Write(" | ");"); Response.Write(data.GetValue(1).ToString()); Response.Write(" | ");"); Response.Write(data.GetValue(2).ToString()); Response.Write(" | ");"); Response.Write(data.GetValue(3).ToString()); Response.Write(" | ");"); Response.Write(data.GetValue(4).ToString()); Response.Write(" | ");
lblDisplayResult.Text = "数据显示完毕!";
data.Close();
conn.Close();
conn.Dispose();
}
protected void btnData_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection();
conn.ConnectionString = "Data Source=PC-2009092011513\\SQLEXPRESS;Initial Catalog=Northwind;User ID=sa;Password=123456";
conn.Open();
SqlCommand comm = new SqlCommand();
comm.CommandText = "update Employees set Country='UK' where Country='英国'";
comm.Connection = conn;
int rows = comm.ExecuteNonQuery();
lblData.Text = rows.ToString();
conn.Close();
conn.Dispose();
}
protected void btnSingeResult_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection();
conn.ConnectionString = "Data Source=PC-2009092011513\\SQLEXPRESS;Initial Catalog=Northwind;User ID=sa;Password=123456";
conn.Open();
SqlCommand comm = new SqlCommand();
comm.CommandText = "select AVG(UnitPrice) from Products as 平均价格 where SupplierID=(select SupplierID from Suppliers where CompanyName='Ma Maison')";
comm.Connection = conn;
float avgPrice = float.Parse(comm.ExecuteScalar().ToString());
lblSingeResult.Text = avgPrice.ToString();
conn.Close();
conn.Dispose();
}
}
急求asp.net连接access数据库代码
asp.net 怎样连接数据库
asp.net连接数据库出错
asp.net连接数据库,急用!
asp.net连接数据库问题
VB.NET连接数据库代码
在Dreamweaver中连接数据库的asp.net vb代码谁知道?
基于vb 开发的asp.net web 应用程序如何用代码连接数据库
asp.net中连接数据库的问题
asp.net怎么连接Oracle数据库?
关于asp.net连接数据库的问题
asp.net 连接数据库错误?找不到数据库文件
.net与sql数据库的连接代码
asp.net连接access的代码
想求下ASP.NET数据库项目开发导航光盘的代码
asp.net 注册代码用vb怎么写(数据库sql)
求ASP.NET中访问ACCESS数据库的代码
ASP.NET 实例怎么打不开
帮一把,谢谢,关于ASP.net连接数据库的问题
asp.net中连接数据库的一点问题
我的数据库和ASP.NET连接不上要什么解决?
为什么ASP。NET页面连接数据库就出错!
asp.net连接SQL server 2000数据库……
ASP.NET连接Access数据库失败原因总结