Guys anyone knows how to create tables at runtime? Or if it is a long story, kindly direct me to a site where I can learn more...
Thanks
markdean.expres
0
Junior Poster
Recommended Answers
Jump to PostNot a long story.
1) Create a connection
2) Create a command containing the same SQL you would use to create it manually
3) cmd.ExecuteNonQuery()Imports System.Data.SqlClient Module Module1 Sub Main() Dim strSQL As String = "CREATE TABLE GRP_CONFIG ( " + _ "SHORT_NAME VARCHAR(8) NOT NULL …
Jump to PostWherever you need it.
It depends on what triggers table creates.
All 8 Replies
thines01
401
Postaholic
Team Colleague
Featured Poster
markdean.expres
0
Junior Poster
thines01
401
Postaholic
Team Colleague
Featured Poster
markdean.expres
0
Junior Poster
thines01
401
Postaholic
Team Colleague
Featured Poster
markdean.expres
0
Junior Poster
thines01
401
Postaholic
Team Colleague
Featured Poster
markdean.expres
0
Junior Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.