我使ID自动增加，现在我想在文本框中显示它 [英] I make Id autoincrimented,now i wanto display that in textbox

问题描述

<div class="  leftbiltyform  ">
           <asp:Label ID="lblconsignorid" runat="server" Text="Id:" Width="40%"></asp:Label>
            <asp:TextBox ID="txtCnsgnrID" runat="server" Width="30%" ></asp:TextBox><br />
           <asp:Label ID="lblconsignorfname" runat="server" Text="First Name:" Width="40%"></asp:Label>
           <asp:TextBox ID="txtCnsgnrFname" runat="server" CssClass="textbox" ></asp:TextBox>
           <br />
           <asp:Label ID="lblConsignorLname" runat="server" Text="Last Name:" Width="40%"></asp:Label>
           <asp:TextBox ID="txtCnsgnrLname" runat="server" CssClass="textbox"></asp:TextBox>
            <br />
             <asp:Label ID="lblConsignorcomname" runat="server" Text="Company Name:" Width="40%"></asp:Label>
             <asp:TextBox ID="txtCnsgnComName" runat="server" CssClass="textbox" ></asp:TextBox>
       <br />
             <asp:Label ID="lblCnsgnrAddress" runat="server" Text="Address:" Width="40%"></asp:Label>
             <asp:TextBox ID="txtCnsgnrAddress" runat="server" CssClass="textbox"></asp:TextBox>
           <asp:Label ID="lblCnsgnrLNo" runat="server" Text="Landline Number" Width="40%"></asp:Label>
           <asp:TextBox ID="txtCnsgnrLNo" runat="server" CssClass="textbox"  ></asp:TextBox><br />
             <asp:Label ID="lblPhNo" runat="server" Text="Phone Number" Width="40%"></asp:Label>
             <asp:TextBox ID="txtCnsgnrPhNo" runat="server" CssClass="textbox"

                ></asp:TextBox><br />
           <asp:Label ID="lblemail" runat="server" Text="Email:" Width="40%"></asp:Label>
           <asp:TextBox ID="txtconrEmail" runat="server" CssClass="textbox"></asp:TextBox><br />
            <div>
                <asp:Button ID="btnSave" runat="server" Text="Save" onclick="btnSave_Click" />
                <asp:Button ID="btnEdit" runat="server" Text="Edit" />
                <asp:Button ID="btnDelete" runat="server" Text="Delete" />
            </div>
         </div>

推荐答案

private void SaveConsigner()
  {
     // int id = 0;
      try
      {
          //objBll.BltId = objGenID.gmGetMstID("BLT", txtCNo.Text);
          //objBll.Consignorid = txtCnsgnrID.Text;
          //get last consigner id from database
          //DAL dalObj = new DAL();
          //id = Int32.Parse(dalObj.getLastId("Consignor")) + 1;
          //objBll.Consignorid = "CNSGNR"+(id.ToString());
          //txtCnsgnrID.Text = objBll.Consignorid;
          //MessageBox.Show(objBll.Consignorid);
          //return;
          objBll.Consignorid = objGenID.gmGetMstID("CNSNR", txtCnsgnrID.Text);
          txtCnsgnrID.Text = objBll.Consignorid;
          objBll.ConsignorFname = txtCnsgnrFname.Text;
          objBll.ConsignorLname = txtCnsgnrLname.Text;
          objBll.ConsignorComanyName = txtCnsgnComName.Text;
          objBll.ConsignorAddress = txtCnsgnrAddress.Text;
          objBll.ConsignorLandlineNo = txtCnsgnrLNo.Text;
          objBll.ConsignorPNo = txtCnsgnrPhNo.Text;
          objBll.ConsignorEmail = txtconrEmail.Text;

          objBll.Save("Consignor", "spInsertConsignor");
          Response.Write("<script>alert('Data Save Successfully')</script>");

          clearMasterInputText();

      }

您可以使用

SELECT SCOPE_IDENTITY()

或

SELECT IDENT_CURRENT(‘tablename’)

您的需求.

作用域标识为您提供了由连接和同一作用域中的语句生成的最后一个IDENTITY值.

ident_current函数返回表中生成的最后一个IDENTITY值.

based on your needs.

Scope identity gives you the last IDENTITY value generated by a connection and a statement in the same scope.

ident_current function returns the last IDENTITY value produced in a table.

我要在保存单击按钮上进行编码的内容，以便id文本框将生成自动递增的id.请帮助

what i want to code on save click button,so that id text box will generate auto incremented id.Please help

这篇关于我使ID自动增加，现在我想在文本框中显示它的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！