aspx从数据库读取数据,aspx网页

1、设置Web.config <?xml version="1.0" encoding="utf-8"?><!-- 有关如何配置 ASP.NET 应用程序的详细信息，请访问 http://go.microsoft.com/fwlink/?LinkId=169433 --><configuration> <system.web> <customErrors mode="Off"/> </system.web> <system.web> <compilation debug="true" targetFramework="4.5" /> <httpRuntime targetFramework="4.5" /> </system.web> <connectionStrings> <add name="TestConnStr1" connectionString="user id=hgjg@sa;password=jhyrf765_67;Data Source=localhost;Initial Catalog=DB1;" providerName="System.Data.SqlClient" /> <add name="TestConnStr2" connectionString="user id=hgjg@sa;password=jhyrf765_67;Data Source=localhost;Initial Catalog=DB2;" providerName="System.Data.SqlClient" /> </connectionStrings></configuration>2、获取数据： protected void Page_Load(object sender, EventArgs e) { String outstr=""; string sqlstr = "SELECT * FROM [TestDB].[dbo].[t_apply]"; SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["TestConnStr1"].ConnectionString); SqlCommand cmd = new SqlCommand(); SqlDataReader reader; cmd.CommandText = sqlstr; cmd.CommandType = CommandType.Text; cmd.Connection = conn; conn.Open(); using (conn) { reader = cmd.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { outstr += "UserID:" + reader.GetInt32(0) + ";"; outstr += "Diamond:" + reader.GetInt64(1) + ";"; outstr += "isAndroiod:" + reader.GetValue(2) + ";"; outstr += "Date:" + reader.GetDateTime(3) + "nr"; } outstr = "hasRow"; } else { outstr = "null"; } Response.Write(outstr); reader.Close(); } }3、操作存储过程： protected void execProd() { SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["TestConnStr2"].ConnectionString); SqlCommand cmd = new SqlCommand(); cmd.CommandText = "t_test_add"; cmd.CommandType = CommandType.StoredProcedure; try { conn.Open(); using (conn) { SqlParameter param1 = new SqlParameter("@uname", SqlDbType.NVarChar, 10); param1.Value = "zhang"; cmd.Parameters.Add(param1); SqlParameter param2 = new SqlParameter("@munt", SqlDbType.Int, 4); param2.Value = 566; cmd.Parameters.Add(param2); SqlParameter param3 = new SqlParameter("@out", SqlDbType.NVarChar, 50); param3.Direction = ParameterDirection.Output; cmd.Parameters.Add(param3); SqlParameter param4 = new SqlParameter("RETURN_VALUE", SqlDbType.NVarChar, 50); param4.Direction = ParameterDirection.ReturnValue; cmd.Parameters.Add(param4); cmd.Connection = conn; object returnValue = cmd.ExecuteScalar(); string s = cmd.Parameters["RETURN_VALUE"].Value.ToString(); Response.Write(s + "==" + param3.Value.ToString());//返回值+output } } catch(System.Data.SqlClient.SqlException e) { Response.Write(e.Message); } }