自动增量帮助 [英] Help for Autoincrement

问题描述

你好朋友，

我进行一次注册，我想像F01一样增加我的用户名，当我选择女性时，想要M01，当我选择男性时，它的代码是什么

hello friends,

I make one registration fourm i want increment my userid like F01 WHEN i select female and want M01 WHEN i select male so what is the code for it
help me.

推荐答案

尝试一下..


我的ASP代码:
在这里，我有性别"的下拉菜单，每当性别名称更改时，我都会在Label:
中填充增量ID.

try this..


My asp Code:
Here i have dropdown for Gender, whenever gender name changes, i populate incrementedId in Label:

<asp:Content ID="BodyContent" runat="server" ContentPlaceHolderID="MainContent">
    <asp:DropDownList runat="server" Id="ddlGender" AutoPostBack="true"

        onselectedindexchanged="ddlGender_SelectedIndexChanged" >
        <asp:ListItem Text="Male" Value="M" />
        <asp:ListItem Text="Female" Value="F" />
    </asp:DropDownList>
    <asp:Label runat="server" ID="IncId" />
</asp:Content>

我的aspx.cs代码在后面.


受保护的void ddlGender_SelectedIndexChanged(对象发送者，EventArgs e)
{
SqlConnection con =新的SqlConnection(数据源= localhost \\ sqlexpress;初始目录= Santhosh；集成安全性= SSPI");
SqlCommand cmd = new SqlCommand(从tbl_user中选择Isnull(MAX(SUBSTRING(Userid，2，LEN(UseriD)-1)，0)+1)，其中USERId类似于""+ ddlGender.SelectedValue +"％"， );
con.Open();
intcrementatedId =(cmd.ExecuteScalar()！= null ||！(cmd.ExecuteScalar()是DBNull))? 字符串ID = ddlGender.SelectedValue + incrementedId.ToString();
IncId.Text = ID;


}


我的样本表和查询以获取最大ID

My aspx.cs code behind.


protected void ddlGender_SelectedIndexChanged(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection("Data Source=localhost\\sqlexpress;Initial Catalog=Santhosh;Integrated Security=SSPI");
SqlCommand cmd = new SqlCommand("Select Isnull(MAX(SUBSTRING(Userid,2,LEN(UseriD)-1),0)+1 from tbl_user where USERId like ''" + ddlGender.SelectedValue + "%''", con);
con.Open();
int incrementedId = (cmd.ExecuteScalar()!=null ||!(cmd.ExecuteScalar() is DBNull))?Convert.ToInt32(cmd.ExecuteScalar()):1;
string Id = ddlGender.SelectedValue+incrementedId.ToString();
IncId.Text = Id;


}


My sample table and query to get max id

create table tbl_user(
UserId varchar(10)
)

insert into tbl_User values ('M01')
insert into tbl_User values ('M02')
insert into tbl_User values ('F123')


select * from tbl_User

Select  MAX(SUBSTRING(Userid,2,LEN(UseriD)-1))+1 from tbl_user where USERId like  'F%'

最终解决方案:
试试这个..
我的ASP代码:
在这里，我有性别"的下拉菜单，每当性别名称更改时，我都会在Label:
中填充增量ID.

Final solution:
Try this..
My asp Code:
Here i have dropdown for Gender, whenever gender name changes, i populate incrementedId in Label:

<asp:Content ID="BodyContent" runat="server" ContentPlaceHolderID="MainContent">
    <asp:DropDownList runat="server" Id="ddlGender" AutoPostBack="true"

        onselectedindexchanged="ddlGender_SelectedIndexChanged" >
        <asp:ListItem Text="Male" Value="M" />
        <asp:ListItem Text="Female" Value="F" />
    </asp:DropDownList>
    <asp:Label runat="server" ID="IncId" />
</asp:Content>

我的aspx.cs代码在后面.

My aspx.cs code behind.

protected void ddlGender_SelectedIndexChanged(object sender, EventArgs e)
{
    SqlConnection con = new SqlConnection("Data Source=localhost\\sqlexpress;Initial Catalog=Santhosh;Integrated Security=SSPI");
    SqlCommand cmd = new SqlCommand("Select Isnull(MAX(UseriD),0)+1 from tbl_user where Gender like '" + ddlGender.SelectedValue + "%'", con);
    con.Open();
    int incrementedId = (cmd.ExecuteScalar()!=null ||!(cmd.ExecuteScalar() is DBNull))?Convert.ToInt32(cmd.ExecuteScalar()):1;
    IncId.Text = ddlGender.SelectedValue+incrementedId.ToString();
}

这篇关于自动增量帮助的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！