Inserting UI data to database

Question

I have a UI page, that already designed with so many controls like textboxes, dropdown, checkboxes etc.   I don't want to declare variables, functions for all inputs in UI to insert to database or is there any other way to do that.   pls let me know.   Thanks in adv.

Pradeep Sahoo · Answer

Create a stored procedure and call the stored procedure to save the data. plz follow like this. for example if you have three field namedCity,FirstName,LastName , you need to do write Stored procedure Create procedure insert (@City,@FirstName,@LastName) { insert into tablename (City,FName,LName) values(@City,@FirstName,@LastName) } call the SP on button click event
SqlConnection con=new sqlconnection("give ur connection string here"); sqlcommand cmd=new sqlcommand(); con.open(); cmd=new sqlcommand("insert",con); cmd.commandtype=commandtype.storedprocedure; cmd.parameters.addwithvalue("@City",txtCity.text); cmd.parameters.addwithvalue("@FName",txtFName.text); cmd.parameters.addwithvalue("@LNAme",txtLName.text); cmd.ExecuteNonQuery(); con.close();