asp.netÖÐÔõÑùµ÷Óô洢¹ý³ÌºÍ´æ´¢¹ý³ÌµÄд·¨

----´´½¨Ò»¸öÖ»ÓÐÊäÈë²ÎÊýµÄ´æ´¢¹ý³Ì
create procedure proc_user
@name varchar(20),
@Password varchar(100)
as
select * from loginuser
where name like @name
---´´½¨Ò»¸öÓÐÊäÈëºÍÊä³ö²ÎÊýµÄ´æ´¢¹ý³Ì
create procedure proc_usertext
@name varchar(20),
@blog varchar(100) output
as
select @blog = blog from loginuser where name = @name
---´´½¨Ò»¸öÓÐÊäÈëºÍ·µ»Ø²ÎÊýµÄ´æ´¢¹ý³Ì
create PROCEDURE returnval
 @name varchar(100),
 @blog varchar(100) output
AS
       begin
       select @blog = blog from loginuser where name = @name
       if(@blog is null)
          set @blog = ''Ä㻹ûÓÐÉêÇ벩¿Í''
       return execute(@blog )  --Êý¾ÝÊýÐ͵Äת»»
       end
ÔÚasp.netÖеĵ÷ÓÃ
protected void Page_Load(object sender, EventArgs e)
    {
        DataBind();
    }
    private void DataBind()
    {
        //Ö»´øÊäÈë²ÎÊýµÄ´æ´¢¹ý³ÌµÄд·¨¡£
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["strConnection"].ConnectionString);
        SqlCommand cmd = new SqlCommand("proc_user", con);
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.AddWithValue("@name", "l%");
        cmd.Parameters.AddWithValue("@Password", "lcs9702");
        con.Open();
        SqlDataReader dr = cmd.ExecuteReader();
        DropDownList1.DataSource = dr;
        DropDownList1.Data