I want to write a block of code that does accepts a username and then stores it into an MSSQL database. My approach to this is to create two objects (edittext and button), the edittext accepts a username, the button is simply a submit mechanic. I then create an onclicklistener, attach it to the submit button, and what it should then do is take the user entered text from the edittext, and store that into the mssql database.
I have a stored procedure that performs this task, I just need to write the supporting code around this function. I am unsure of where to put the required code (the syntax), do I open the connection, execute the SP and then close the connection all within the onclicklistener? What would that code look like? Please note that of course in the grand scheme of things I'm going to need to embellish the code to expand the acceptable parameters (such as checking to see if an identical username exists and such) but for the time being all I want to do exactly what I described.
User clicks "submit" after entering their new username, stored procedure executes and stores that username into a database.
