怎么在asp.net中使用存储过程啊..最好有输出和输入参数的过程

Question

项目要求,急

Answer 1

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
//照着写就OK
public partial class _Default : System.Web.UI.Page 
{
    private SqlConnection Conn()
    {
        return new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True;User Instance=True");
    }    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            using (SqlConnection conn = Conn())
            {
                conn.Open();
                SqlDataAdapter adapter = new SqlDataAdapter("ShowNodeID", conn);
                adapter.SelectCommand.CommandType = CommandType.StoredProcedure;
                DataSet ds = new DataSet();
                adapter.Fill(ds, "nodeID");
                DropDownList1.DataSource = ds.Tables["nodeID"];
                DropDownList1.DataTextField = "nodeID";
                DropDownList1.DataValueField = "nodeID";
                DropDownList1.DataBind();            }
            using (SqlConnection conn = Conn())
            {
                conn.Open();
                SqlDataAdapter adapter = new SqlDataAdapter("ShowNodeName", conn);
                adapter.SelectCommand.CommandType = CommandType.StoredProcedure;
                DataSet ds = new DataSet();
                adapter.Fill(ds, "nodeName");
                GridView1.DataSource = ds.Tables["nodeName"];
                ds.Tables["nodeName"].Columns[0].ColumnName = "名称";
                GridView1.DataBind();
            }
        }
    }    protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
    {
        using (SqlConnection conn = Conn())
        {
            conn.Open();
            SqlDataAdapter adapter = new SqlDataAdapter("ShowNodeNameByNodeID", conn);
            adapter.SelectCommand.CommandType = CommandType.StoredProcedure;
            adapter.SelectCommand.Parameters.Add(new SqlParameter("@NodeID", DropDownList1.SelectedValue));
            SqlParameter abc = new SqlParameter("@OutNodeName", SqlDbType.NVarChar);
            abc.Direction = ParameterDirection.Output;
            abc.Size = 400;
            adapter.SelectCommand.Parameters.Add(abc);
            DataSet ds = new DataSet();
            adapter.Fill(ds,"abc");
            this.Title = adapter.SelectCommand.Parameters["@OutNodeName"].Value.ToString();
        }
    }
}//过程如下
ALTER PROCEDURE dbo.ShowNodeID
/*
(
@parameter1 int = 5,
@parameter2 datatype OUTPUT
)
*/
AS
/* SET NOCOUNT ON */ 
select nodeID from node
RETURNALTER PROCEDURE dbo.ShowNodeName
/*
(
@parameter1 int = 5,
@parameter2 datatype OUTPUT
)
*/
AS
/* SET NOCOUNT ON */ 
select  nodeName from node  order by  nodeDateTime
RETURNALTER PROCEDURE dbo.ShowNodeNameByNodeID
/*
(
@parameter1 int = 5,
@parameter2 datatype OUTPUT
)
*/
(
@NodeID int,
@OutNodeName nvarchar(400) OUTPUT
)
AS
/* SET NOCOUNT ON */ 
select   @OutNodeName = nodeName  from node where NodeID = @NodeID

Answer 2

http://blog.csdn.net/xuStanly/archive/2007/10/11/1820157.aspx