Loading

How to add column in database dynamically in mvc

suman goud

i have emp table in database(sql server) ,

i want to add columns dynamically for that

in my view page i given Name(textbox), datatype(dropdown)

if i click save i want add column in db.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Salman Beg10y ago
one more thing you can pass table name also as a parameter in which table you want to update it.
thanks
0
Salman Beg10y ago
Hi.
Yes you can do that and for that you need to write a proc and in that you pass two parameter as name and datatype. The proc should be like

Alter proc test
@Name varchar(20),
@type varchar(100)
begin
ALTER TABLE employees
ADD @Name @type;
end
and please write the code for how to call and pass data in your proc inside your
save button.
thanks.
0