I want to create a new table to sql database at runtime. The column names would be "Name", "Date", "Event". I would also like to have one more column name "Image" but the problem is that since the amount of images will vary, I want the application to count the amount of files in the Multiple fileuploader and then add a image column to the table for the respected amount of files.
For example if i am uploading 3 files in the multiple fileuploader, the names should be "Name", "Date", "Event", "Image1", "image2", Image3"
I also would like that table name to be name dynamically from the textbox Name when the user enters the information.
I have the following code to make a new table, but I dont know how to name the fields at runtime like previously asked please help!!!
Dim objConn As New SqlConnection("Server=<servername>;uid=<userid>;pwd=<password>;database=master")