调用存储过程！sqlhelp

插入（insert into ）

存储过程为：CREATE PROCEDURE [mypro]
@code varchar(50),
@type varchar(50),
@name varchar(50)
AS insert into prm values (@code,@type,@name)
GO

在C#中：

           try
            {
                SqlParameter[] app = new SqlParameter[3];
                app[0] = new SqlParameter("@code", SqlDbType.VarChar, 50);
                app[0].Value = this.textBoxX1.Text.Trim();
                app[1] = new SqlParameter("@type", SqlDbType.VarChar, 50);
                app[1].Value = this.textBoxX2.Text.Trim();
                app[2] = new SqlParameter("@name", SqlDbType.VarChar, 50);
                app[2].Value = this.textBoxX3.Text.Trim();
                SqlHelper.ExecuteNonQuery(strconn, CommandType.StoredProcedure, "mypro", app);
            }

            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString(), "error");
                return;
            }

取出（select *）

存储过程：CREATE PROCEDURE [dbo].[semypro]
AS
select * from prm
GO

在C#中：

System.Data.SqlClient.SqlDataReader drerer;
            try
            {
                drerer = SqlHelper.ExecuteReader(strconn, CommandType.StoredProcedure, "semypro");
                while (drerer.Read())
                {
                    this.textBoxX1.Text = drerer[1].ToString().Trim();
                    this.textBoxX2.Text = drerer[2].ToString().Trim();
                    this.textBoxX3.Text = drerer[3].ToString().Trim();
                    break;
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString(), "error");
                return;
            }

哈，自己摸索，不知道可有更好的方法！