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.Sql;
using System.Data.SqlClient;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection("server=.;database=db_test;pwd=;uid=sa;");
SqlCommand cmd = new SqlCommand("db_test", con);
cmd.CommandType = CommandType.StoredProcedure;
con.Open();
try
{
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
int i=0;
if (dr[i].ToString() != string.Empty)
{
Response.Write("<script>alert('数据显示成功!'+" + dr[i].ToString() + ")</script>");
i++;
}
con.Close();
}
}
catch (Exception ee)
{
con.Close();
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
Response.Write("<script>alert('数据显示成功!')</script>");
SqlConnection con = new SqlConnection("server=.;database=db_test;pwd=;uid=sa;");
SqlCommand cmd = new SqlCommand("db_test",con);
cmd.CommandType = CommandType.StoredProcedure;
con.Open();
try
{
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
Response.Write("<script>alert('数据显示成功!'+" + dr[0].ToString() + ")</script>");
{
if (dr[0].ToString() !=string.Empty)
{
Response.Write("<script>alert('数据显示成功!'+"+dr[0].ToString()+")</script>");
}
con.Close();
}
}
catch (Exception ee)
{
con.Close();
}
}
}
存储过程代码
CREATE procedure db_test as
select * from tb_test order by ID DESC
GO