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:
blUser.addUA3(idUser, idS,
txtLastName.Text,
txtFirstName.Text,
txtMiddleName.Text,
drpUserType.Text,
txtUsername.Text);
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);
}
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);
}