SQL储存过程的简单问题~

[loveksmy]

我有个数据库 A
里面有表 info 字段 ID(自动编号),TITLE,CONTENT

我想请问下，我怎么创建添加信息的储存过程？

另外我在VS2005中，怎么调用这个储存过程
比如我有个文本框 TITLE,有一内容文本框 CONTENT
我点了按钮之后代码是怎么样的？

先谢谢各位了~
虚心学习ING

[Krismeng]

来晚了。。。。

[yagebu1983]

UP一下！！！

[s208ping]

create procedure 存储过程名 
( 
    @name varchar (20), 
    @pwd varchar(10) 
) 
as 
insert into (name,pwd)values(@name,@pwd) 
go 

[loveksmy]

谢谢各位大哥大姐
小弟成功后代码，供大家学习交流

   
 protected void Button1_Click(object sender, EventArgs e)
    {
        SqlConnection conn = new SqlConnection();
        conn.ConnectionString = "Server=(local);UID=sa;PWD=;DataBase=Article";//数据连接字符串 
        conn.Open();
        SqlCommand cmd = conn.CreateCommand();
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.Add("@title", SqlDbType.VarChar, 255).Value = TextBox1.Text.Trim();
        cmd.Parameters.Add("@content", SqlDbType.VarChar, 255).Value = TextBox2.Text.Trim();
        cmd.CommandText = "a_insert";
        cmd.ExecuteNonQuery();
        conn.Close();
    }

    <form id="form1" runat="server">
    <div>
        <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
        <asp:TextBox ID="TextBox2"  runat="server"></asp:TextBox><asp:Button ID="Button1"
            runat="server" Text="Button" OnClick="Button1_Click" />
    </div>
    </form>

CREATE PROCEDURE a_insert 
(@title varchar(255),@content varchar(255))
AS
insert into Article(title,content)values(@title,@content)
GO

[wangping_li]

[Quote=引用 10 楼 loveksmy 的回复:]
谢谢各位大哥大姐
小弟成功后代码，供大家学习交流
[/Quote]
楼主真好心~

[conan304]

create procedure proc_insert
(@title varchar(255),@content varchar(255))
AS
insert info(title,content)
select @title,@content

go

SqlConnection conn = new SqlConnection();
conn.ConnectionString = "";//数据连接字符串
conn.Open();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.ExecuteNonQuery();
conn.Close();

[conan304]

Sorry,忘记加参数了。

SqlConnection conn = new SqlConnection();
conn.ConnectionString = "";//数据连接字符串
conn.Open();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@title", SqlDbType.VarChar, 255).Value = TextBox1.Text.Trim();
cmd.Parameters.Add("@content", SqlDbType.VarChar, 255).Value = TextBox2.Text.Trim();
cmd.ExecuteNonQuery();
conn.Close();

[shoushii]

回答的越来越专业了，偶来晚了

[conan304]

Sorry，忘记加存储过程名了，大汗
SqlConnection conn = new SqlConnection();
conn.ConnectionString = "";//数据连接字符串
conn.Open();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "proc_insert";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@title", SqlDbType.VarChar, 255).Value = TextBox1.Text.Trim();//文本框title值
cmd.Parameters.Add("@content", SqlDbType.VarChar, 255).Value = TextBox2.Text.Trim();//文本框content值
cmd.ExecuteNonQuery();
conn.Close();

[kevin520bj]

SqlConnection conn = new SqlConnection();
conn.ConnectionString = "";//数据连接字符串
conn.Open();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@title", SqlDbType.VarChar, 255).Value = TextBox1.Text.Trim();
cmd.Parameters.Add("@content", SqlDbType.VarChar, 255).Value = TextBox2.Text.Trim();
cmd.CommandText = "proc_insert";
cmd.ExecuteNonQuery();
conn.Close();

[BuleMiniCoper]

create procedure 存储过程名
(
@name varchar (20),
@pwd varchar(10)
)
as
insert into (name,pwd)values(@name,@pwd)
go

.cs文件中

SqlConnection conn = new SqlConnection();
conn.ConnectionString = "";//数据连接字符串
conn.Open();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@title", SqlDbType.VarChar, 255).Value = TextBox1.Text.Trim();
cmd.Parameters.Add("@content", SqlDbType.VarChar, 255).Value = TextBox2.Text.Trim();
cmd.CommandText = "存储过程名称";
cmd.ExecuteNonQuery();
conn.Close();

[jason87629]

学习了！！！