ADO.NET 调用存储过程示例

1.创建表：
create table testtb ( idd int not null,
content varchar(50)
)

2.创建存储过程
create PROCEDURE myprocedure
@count int,
@Isok varchar(50) OUTPUT

AS
declare @maxindex int
select @maxindex=count(*) from testtb ;
while @count>0
begin
insert into testtb (idd,content) values(@count+@maxindex,'content'+convert(varchar(10),@count+@maxindex));

set @count=@count-1;
end

set @Isok='ok';

RETURN

3.创建简单 Windows form 实现调用存储过程：
界面代码：

处理代码：
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace ConsoleApplication1
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            String constr = "Data Source=KMGOAL;Initial Catalog=Northwind;Integrated Security=True";

           //关键代码：
             SqlConnection con = new SqlConnection(constr);
            SqlCommand scd = new SqlCommand("myprocedure", con);
            scd.CommandType =CommandType.StoredProcedure;

SqlParameter parameter1 = scd.Parameters.Add("@count", SqlDbType.Int );
parameter1.Value =int.Parse(this .textBox1 .Text); // scd.Parameters["@create_count"] =10;

            SqlParameter parameter2 = scd.Parameters.Add( "@Isok", SqlDbType.VarChar ,10 );
            parameter2.Direction = ParameterDirection.Output;
            con.Open();
            scd.ExecuteNonQuery( );
            con.Close();

        this.label2.Text = scd.Parameters["@Isok"].Value.ToString();

        }

        private void Form1_Load(object sender, EventArgs e)
        {
            button1.Click+= new EventHandler(button1_Click);
        }

        public static void Main()
        {
            Application.EnableVisualStyles();
            Application.Run(new Form1());

}
}

posted @ 2008-08-23 05:02 7goal 阅读(1538) 评论(0) 收藏举报

刷新页面返回顶部