 |  |  |  |  |  |  |  |
Where is the table ????
Please support our ASP.NET advertiser: Intel Parallel Studio Home
 |
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
•
•
•
•
Originally Posted by infinity4ever
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
This is my first time to this forum,
I am a begginer of database programming,
To your problem, I suggest that you add the conn.open()
conn.close() SQLCreate.dispose, DA.DataBind()(this is after the
code DA.Fill(DS)).
If i am not right please correct me
Thank you
hi embeza
thx for replying to me... i appreciate your helping
but there is no need for conn.open() and conn.close() because when you use the dataset its automatically open the connection and close it
but i think is that DA.DataBind()
i'll try it and thanks alot for ur comments
thx for replying to me... i appreciate your helping
but there is no need for conn.open() and conn.close() because when you use the dataset its automatically open the connection and close it
but i think is that DA.DataBind()
i'll try it and thanks alot for ur comments
•
•
Join Date: Jul 2005
Posts: 483
Reputation: 
Solved Threads: 19
Posting Pro in Training
which database are you looking in when you open sql and don't see it?
I'm guessing that you are creating the table on the default database for that user, instead of the database you are looking at. try master or one of the other databases
I'm guessing that you are creating the table on the default database for that user, instead of the database you are looking at. try master or one of the other databases
•
•
•
•
Originally Posted by campkev
which database are you looking in when you open sql and don't see it?
I'm guessing that you are creating the table on the default database for that user, instead of the database you are looking at. try master or one of the other databases
I am Embeza.
I would like to know the meaning of the ConnectionString= "Data......."
I just dont know the DataSource,AttachDbFileName...."
Can you help plZZ.
With regard
What you are doing is still not correct. You are passing a Select Command Object a Create Table Statement and then trying to fill a dataset (a SELECT query result set, which you are not doing) with the result.
There is logically no reason you should ever create a table from the front end. The table should already exist in the Database.
There is logically no reason you should ever create a table from the front end. The table should already exist in the Database.
Last edited by Paladine; Jun 24th, 2006 at 2:02 am.
hi sorry to be late i didnt have time check the site...
Campkev:
that was the first thing i did...i search in the master and the other database but i didnt find the table i created.
Embeza:
emmm am not very good at explaining but i'll try... actually you are declearing an sqlconnection to establish a connection to the sql database... the connection string include the data source for example if it is from sqlexpress or another version... the attachdbname is the database am using in my project whitch is named RBD in my project... you have other things like integrated security and what is the connection timeout
if am mistaken or not clear i hope that someone explain in better way to embeza.
Paladine:
do you know the correct code to do it ??...its been 3 weeks since am trying to perform this.... in my project i need to create table at the front-end coz each created table will be defferent than the other one, upon to the end-user request...thats why i cant work on an existing table because i dont know what are the tables the end-users want to create.
Campkev:
that was the first thing i did...i search in the master and the other database but i didnt find the table i created.
Embeza:
emmm am not very good at explaining but i'll try... actually you are declearing an sqlconnection to establish a connection to the sql database... the connection string include the data source for example if it is from sqlexpress or another version... the attachdbname is the database am using in my project whitch is named RBD in my project... you have other things like integrated security and what is the connection timeout
if am mistaken or not clear i hope that someone explain in better way to embeza.
Paladine:
do you know the correct code to do it ??...its been 3 weeks since am trying to perform this.... in my project i need to create table at the front-end coz each created table will be defferent than the other one, upon to the end-user request...thats why i cant work on an existing table because i dont know what are the tables the end-users want to create.
Here is a link to doing in Visual Basic.NET, so you will have to make some modifications to this inorder to make it work.
http://msdn2.microsoft.com/en-us/library/ms162203.aspx
http://msdn2.microsoft.com/en-us/library/ms162203.aspx
Last edited by Paladine; Jun 24th, 2006 at 5:22 am.
|
Similar Threads
- 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
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest ASP.NET Posts
- Today's Posts
- Unanswered Threads
.net 2.0 3.5 activexcontrol advice ajax alltypeofvideos asp asp.net bc30451 bottomasp.net browser businesslogiclayer button c# c#gridviewcolumn checkbox class click commonfunctions compatible confirmationcodegeneration content contenttype control countryselector courier css database datagrid datagridview datagridviewcheckbox datalist deadlock deployment development dgv dropdownlist dropdownmenu dynamic edit embeddingactivexcontrol expose findcontrol flash flv formatdecimal forms formview gridview homeedition iframe iis javascript jquery list login menu microsoft mono mssql multistepregistration nameisnotdeclared numerical objects order panelmasterpagebuttoncontrols problem ratings rotatepage save schoolproject search security serializesmo.table silverlight smartcard sql sqlserver2005 ssl suse textbox tracking unauthorized validation vb.net video virtualdirectory vista visual-studio visualstudio vs2008 web webarchitecture webdevelopemnt webdevelopment webservice wizard xml youareanotmemberofthedebuggerusers
