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")
objConn.Open()