asp.net - Web application dynamically adding controls in FormView, columns in GridView and parameters in Store Procedures -


i want make job easier , not time when have additional column add need add column in gridview, formview, stored procedure insert, update, select. possible when add new row in table add dynamically on places in code. example have table this:

 table   (column_id, column_name)  (1, 500);  (2, 400);  (3, 300);  (4, 200);  (5, 100); 

what want make these row values (500,400,300,200,100) names of columns in gridview , id names of textboxes in formview. if have add example new row in table:

6, 500

i want new row dynamically added everywhere in code (gridview, formview, stored procedure insert, update, select).

i more confused , worried adding dynamically new parameter in store procedures, because @ start have declare numbers of parameters sent procedures or there , way make , that. know can send data in 1 parameters , parsing parameter on many parameters have values in parameter don't know practical , reliable.

the aim of not have mess every time code when want add or delete column application.

any more enough. advise, code or site can read more that.


Comments

Popular posts from this blog

asynchronous - C# WinSCP .NET assembly: How to upload multiple files asynchronously -

aws api gateway - SerializationException in posting new Records via Dynamodb Proxy Service in API -

asp.net - Problems sending emails from forum -