ASPX操作数据库

来源：互联网发布：淘宝网涵元服饰编辑：程序博客网时间：2024/06/01 07:51

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) + "\n\r";                }                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);        }    }

0 0