what should i use to make the data inserted is in all capital letter?
here is insert statement:
[CODE] string query = "INSERT into Categories values (' " + textbox5_value + " ', ' " + textbox6_value + " ', ' " + textbox7_value + " ' )";[/CODE]
strToUpper() is used to make it convert to all capital letter but i don't know where should i put it? can i use this?[/QUOTE]You can do it in the following way assuming that your values are already in string form:[CODE]string query = "INSERT into Categories values (' " + textbox5_value.ToUpper() + " ', ' " + textbox6_value.ToUpper() + " ', ' " + textbox7_value.ToUpper() + " ' )";[/CODE]However, if the input is not in string form then you will need to convert to string prior to appending the .ToUpper().