Click here to Skip to main content
15,919,500 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Please help me in capitalizing the first letter enter on these textboxes txtLastName, txtFirstName, txtMiddleName here's how I insert the data on the database:

VB
blUser.addUA3(idUser, idS,
                    txtLastName.Text,
                   txtFirstName.Text,
                   txtMiddleName.Text,
                 drpUserType.Text,
                 txtUsername.Text);


C#
public void addUA3(int id,
         int officeID,
            string LastName,
             string FirstName,
             string MiddleName,
             string UserType,
               string UserName)
       {
           DAUsers DAUA = new DAUsers();

           DAUA.addUA3DA(id, officeID, LastName,
              FirstName,
              MiddleName,
            UserType,
            UserName);
       }


C#
public void addUA3DA(int id,
                  int officeID,
                      string LastName,
                      string FirstName,
                      string MiddleName,
                      string UserType,
                    string UserName)
        {
            string sql = "INSERT INTO UserAccount (SchoolOfficeID,LastName,FirstName,MiddleName,UserType,UserName,Password,AccntStatus) VALUES (@SchoolOfficeID, @LastName,@FirstName,@MiddleName,@UserType,@UserName,@Password,@AccntStatus)";
            DbParameter[] paramBlog = new DbParameter[]
            {
                MakeParameter("@SchoolOfficeID",officeID,DbType.Int32),
                MakeParameter("@LastName",LastName,DbType.String),
                MakeParameter("@FirstName",FirstName,DbType.String),
                MakeParameter("@MiddleName",MiddleName,DbType.String),
                MakeParameter("@UserType",UserType,DbType.String),
                MakeParameter("@UserName",LastName + "_" + FirstName[0] + FirstName[1],DbType.String),
                   MakeParameter("@Password","123456",DbType.String),
                MakeParameter("@AccntStatus","Active",DbType.String)
            };
            RunNonQuery(sql, paramBlog);
        }
Posted
Comments
Harshil_Raval 11-Sep-13 9:20am    
hi, just add this css to your textbox. <asp:Textbox style="text-transform:capitalize;" ..>
timJosh 11-Sep-13 9:30am    
Ok tnx I'll try it. :)
timJosh 11-Sep-13 9:40am    
It doesn't work.
Thomas Barbare 11-Sep-13 10:33am    
Css should work, but depends on your doctype and client browser etc

Hi just use this instead of your textboxes

C#
textBox1.Text = textBox1.Text.Substring(0, 1).ToUpper() + textBox1.Text.Remove(0, 1);


:Dooslt
 
Share this answer
 
Comments
timJosh 11-Sep-13 12:38pm    
It actually worked tnx.
i.fakhari 11-Sep-13 12:54pm    
you're welcome
Add this method

C#
private static string Capitalize(string input)
        {
            string firstLetter = input[0].ToString().ToUpper();
            input = input.Remove(0, 1);
            input = input.Insert(0,firstLetter);
            return input;
        }


and then

C#
blUser.addUA3(idUser, idS,
                    Capitalize(txtLastName.Text),
                   Capitalize(txtFirstName.Text),
                   Capitalize(txtMiddleName.Text),
                 drpUserType.Text,
                 txtUsername.Text);
 
Share this answer
 
v3
Comments
timJosh 11-Sep-13 10:40am    
I'm getting an erro pls help me this is the message I'm getting: A property, indexer or dynamic member access may not be passed as an out or ref
Thomas Barbare 11-Sep-13 10:56am    
Sorry I made a mistake look at my correction
aspx:

txtFirstName.Text = txtFirstName.Text.Substring(0, 1).ToUpper() + txtFirstName.Text.Remove(0, 1);


cs file:

<asp:textbox id="txtFirstName" runat="server" width="250px" style="text-transform:capitalize;" xmlns:asp="#unknown">
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900