置顶随笔

[置顶]存储过程没有返回值,急!!!

SqlCommand sqlcomm = new SqlCommand("AdminInsert", sqlconn);
        sqlcomm.CommandType = CommandType.StoredProcedure;
        sqlcomm.Parameters.Add("@LoginName", SqlDbType.VarChar, 20).Value = AdminLoginTextBox.Text;
        sqlcomm.Parameters.Add("@PassWord", SqlDbType.Char, 20).Value = AdminPassWordTextBox1.Text;
        sqlcomm.Parameters.Add("@Name", SqlDbType.VarChar, 20).Value = AdminNameTextBox.Text;
        sqlcomm.Parameters.Add("@Email", SqlDbType.VarChar, 30).Value = AdminEmailTextBox.Text;
        sqlcomm.Parameters.Add("@Phone", SqlDbType.Char, 15).Value = AdminTelTextBox.Text;
        sqlcomm.Parameters.Add("@Result", SqlDbType.Int);
        sqlcomm.Parameters["@Result"].Direction = ParameterDirection.Output;
        i = Convert.ToInt32(sqlcomm.Parameters["@Result"].Value);

CREATE PROCEDURE AdminInsert
@LoginName varchar(20),
@PassWord char(20),
@Name varchar(20),
@Email varchar(30),
@Phone char(15),
@Result int output
AS
set nocount on
set xact_abort on
select * from Users where U_LoginName=@LoginName
if @@rowcount=0
  begin
    begin transaction
      insert into Users(U_LoginName,U_PassWord,U_Name,U_Email,U_Tel,U_Flags)
      values(@LoginName,@PassWord,@Name,@Email,@Phone,1)
    if @@error=0
      begin
        set @Result=1
        commit transaction
 return
      end
    else
      begin
        rollback transaction
        set @Result=2
 return
        end
  end
else
  set @Result=3
return
set xact_abort off
GO

为什么"i"取到的值都是0,也就是"sqlcomm.Parameters["@Result"].Value"一直是NUll

posted @ 2007-01-09 14:33 吴本 阅读(135) | 评论 (1) | 编辑

[置顶]哪位大哥救命啊！！！

                    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="a" OnRowEditing="GridView1_RowEditing">
                        <Columns>
                            <asp:TemplateField>
                                <Itemtemplate>
                                    <asp:CheckBox ID="CheckBox1" runat="server" />
                                </Itemtemplate>
                            </asp:TemplateField>
                            <asp:BoundField HeaderText="ID" DataField="a" SortExpression="a" Visible="false" />
                            <asp:BoundField HeaderText="姓名" DataField="b" SortExpression="b"  />
                            <asp:BoundField HeaderText="年龄" DataField="c" SortExpression="c" />
                            <asp:BoundField HeaderText="性别" DataField="d" SortExpression="d" />
                            <asp:TemplateField>
                                <ItemTemplate>
                                    <asp:LinkButton ID="LinkButton1" CommandName="Edit" runat="server">编辑
                                    </asp:LinkButton>
                                </ItemTemplate>
                            </asp:TemplateField>
                        </Columns>
                    </asp:GridView>

                    <asp:Button ID="deletebutton" runat="server" Text="delete" OnClick="deletebutton_Click" />

    protected void deletebutton_Click(object sender, EventArgs e)
    {
                     foreach (GridViewRow gvr in GridView1.Rows)
        {
            CheckBox cb = gvr.FindControl("CheckBox1");
            if (cb.Checked)
            {
                //删除怎么写？
            }
        }
    }

我若把<asp:CheckBox>类型换成<input>类型时又怎么做？
哪位大虾救救

posted @ 2006-12-25 13:03 吴本 阅读(253) | 评论 (9) | 编辑

2007年1月9日

存储过程没有返回值,急!!!

SqlCommand sqlcomm = new SqlCommand("AdminInsert", sqlconn);
        sqlcomm.CommandType = CommandType.StoredProcedure;
        sqlcomm.Parameters.Add("@LoginName", SqlDbType.VarChar, 20).Value = AdminLoginTextBox.Text;
        sqlcomm.Parameters.Add("@PassWord", SqlDbType.Char, 20).Value = AdminPassWordTextBox1.Text;
        sqlcomm.Parameters.Add("@Name", SqlDbType.VarChar, 20).Value = AdminNameTextBox.Text;
        sqlcomm.Parameters.Add("@Email", SqlDbType.VarChar, 30).Value = AdminEmailTextBox.Text;
        sqlcomm.Parameters.Add("@Phone", SqlDbType.Char, 15).Value = AdminTelTextBox.Text;
        sqlcomm.Parameters.Add("@Result", SqlDbType.Int);
        sqlcomm.Parameters["@Result"].Direction = ParameterDirection.Output;
        i = Convert.ToInt32(sqlcomm.Parameters["@Result"].Value);

CREATE PROCEDURE AdminInsert
@LoginName varchar(20),
@PassWord char(20),
@Name varchar(20),
@Email varchar(30),
@Phone char(15),
@Result int output
AS
set nocount on
set xact_abort on
select * from Users where U_LoginName=@LoginName
if @@rowcount=0
  begin
    begin transaction
      insert into Users(U_LoginName,U_PassWord,U_Name,U_Email,U_Tel,U_Flags)
      values(@LoginName,@PassWord,@Name,@Email,@Phone,1)
    if @@error=0
      begin
        set @Result=1
        commit transaction
 return
      end
    else
      begin
        rollback transaction
        set @Result=2
 return
        end
  end
else
  set @Result=3
return
set xact_abort off
GO

为什么"i"取到的值都是0,也就是"sqlcomm.Parameters["@Result"].Value"一直是NUll

posted @ 2007-01-09 14:33 吴本 阅读(135) | 评论 (1) | 编辑

2006年12月31日

网页后台管理,急

我想知道网页后面管理主要职责是什么,一般都做些什么事?数据的维护吗?

posted @ 2006-12-31 13:01 吴本 阅读(925) | 评论 (6) | 编辑

2006年12月25日

哪位大哥救命啊！！！

                    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="a" OnRowEditing="GridView1_RowEditing">
                        <Columns>
                            <asp:TemplateField>
                                <Itemtemplate>
                                    <asp:CheckBox ID="CheckBox1" runat="server" />
                                </Itemtemplate>
                            </asp:TemplateField>
                            <asp:BoundField HeaderText="ID" DataField="a" SortExpression="a" Visible="false" />
                            <asp:BoundField HeaderText="姓名" DataField="b" SortExpression="b"  />
                            <asp:BoundField HeaderText="年龄" DataField="c" SortExpression="c" />
                            <asp:BoundField HeaderText="性别" DataField="d" SortExpression="d" />
                            <asp:TemplateField>
                                <ItemTemplate>
                                    <asp:LinkButton ID="LinkButton1" CommandName="Edit" runat="server">编辑
                                    </asp:LinkButton>
                                </ItemTemplate>
                            </asp:TemplateField>
                        </Columns>
                    </asp:GridView>

                    <asp:Button ID="deletebutton" runat="server" Text="delete" OnClick="deletebutton_Click" />

    protected void deletebutton_Click(object sender, EventArgs e)
    {
                     foreach (GridViewRow gvr in GridView1.Rows)
        {
            CheckBox cb = gvr.FindControl("CheckBox1");
            if (cb.Checked)
            {
                //删除怎么写？
            }
        }
    }

我若把<asp:CheckBox>类型换成<input>类型时又怎么做？
哪位大虾救救

posted @ 2006-12-25 13:03 吴本 阅读(253) | 评论 (9) | 编辑

仅列出标题  
<2008年12月>
日一二三四五六
30123456
78910111213
14151617181920
21222324252627
28293031123
45678910

导航

统计

与我联系

搜索

 

常用链接

留言簿

我参与的团队

随笔档案

最新评论

阅读排行榜

评论排行榜