Create an sp as shown below
create procedure [dbo].[PDynamicTable]
(
@tname varchar(20),
@col1 varchar(20),
@col2 varchar(20)
)
as
begin
declare @a varchar(2000);declare @b varchar(200);
set @a='create table [dbo].['+@tname+'](';
set @b=@a+@col1+ ' varchar(200),'+@col2+''+ ' varchar(200);
--print @b;
exec(@b);
end
then write the following asp.net code in your button click .
SqlConnection con = new SqlConnection("Data Source=SHANTANU\\SQLEXPRESS;Initial Catalog=dynamicdata;Integrated Security=True");
string qry="PDynamicTable";
SqlCommand cmd = new SqlCommand(qry,con);
try
{
sqlparameter p1=new sqlparameter("@tname",sqldbtype.varchar,20);
sqlparameter p2=new sqlparameter("@col1",sqldbtype.varchar,200);
sqlparameter p3=new sqlparameter("@col2",sqldbtype.varchar,200);
p1.value=TextBox1.Text;
p2.value=TextBox2.Text;
p3.value=TextBox3.Text;
cmd.parameters.Add(p1);
cmd.parameters.Add(p2);
cmd.parameters.Add(p3);
con.Open();
cmd.ExecuteNonQuery();
Response.Write("<script>alert('Table Created')</script>");
}
catch (System.Exception ex)
{
Response.Write("<script>alert('Table Created failed')</script>");
ex.ToString();
}
finally{
con.Close();
}
}
}
Note: this code is not verified in visual studio . I always use
c# interview questions and answers present in http://skillgun.com website .