•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the ASP.NET section within the Web Development category of DaniWeb, a massive community of 402,471 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,966 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our ASP.NET advertiser: Lunarpages ASP Web Hosting
Views: 1245 | Replies: 8
•
•
Join Date: Jun 2006
Posts: 22
Reputation: 
Rep Power: 3
Solved Threads: 0
Newbie Poster
hi... i create a new table with this code
Dim SQLCreate As New SqlCommand
Dim Conn As New SqlConnection
Dim DA As New SqlDataAdapter
Dim DS As New Data.DataSet
'Create DB
SQLCreate.CommandText = "CREATE TABLE test (ID integer NOT NULL)"
SQLCreate.Connection = Conn
Conn.ConnectionString = "Data
Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\RBD.mdf;Integrated
Security=True;Connect Timeout=30;User Instance=True"
DA.SelectCommand = SQLCreate
DA.Fill(DS)
the code works perfectly... but i dont know where the created table is??? when i open the sql server from Visual Studio.net 2005 it shows that the table test is there but when i close it and run microsoft sql 2005 i didn't find the table there!!!!!!!!! i restarted the pc and check again..the table is there in vs2005 but still not in microsoft sql 2005
even if i run the application and pess the button again it tells me that the table test is already there??!!!! so why it is not shown in microsoft sql server 2005??
what is the issue here? i want to save the table as a permenent table not temporary one
Dim SQLCreate As New SqlCommand
Dim Conn As New SqlConnection
Dim DA As New SqlDataAdapter
Dim DS As New Data.DataSet
'Create DB
SQLCreate.CommandText = "CREATE TABLE test (ID integer NOT NULL)"
SQLCreate.Connection = Conn
Conn.ConnectionString = "Data
Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\RBD.mdf;Integrated
Security=True;Connect Timeout=30;User Instance=True"
DA.SelectCommand = SQLCreate
DA.Fill(DS)
the code works perfectly... but i dont know where the created table is??? when i open the sql server from Visual Studio.net 2005 it shows that the table test is there but when i close it and run microsoft sql 2005 i didn't find the table there!!!!!!!!! i restarted the pc and check again..the table is there in vs2005 but still not in microsoft sql 2005
even if i run the application and pess the button again it tells me that the table test is already there??!!!! so why it is not shown in microsoft sql server 2005??
what is the issue here? i want to save the table as a permenent table not temporary one
•
•
•
•
•
•
•
•
DaniWeb ASP.NET Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Threaded Mode- Adding a record from a table to another (VB.NET)
- How can i deledet and update from table ??????? (PHP)
- Copying table from one mdb to another (ASP)
- Need help with HTMl Table echoing? (PHP)
- Table of Contents Script (Java)
Other Threads in the ASP.NET Forum
- Previous Thread: variables from javascript in asp.net
- Next Thread: Form request help
