Hi,
create a table in vb.net connect with sql server.
i know create a sql table in sql server 2000. but i don't know vb.net using runtime create a table.
pleasew help me.
thanks
create sql table in vb.net code
Hot Topic
- How to detect SQL SERVER ON LINE or OFF Line
- Saving ID Values in Tables
- Most efficient way to insert text into a file
- Creating a text file with the landscape orientation with vb.net
- i want to open a url in a browser and i want to move cursor all over the brower???
- TNS error through visual studio connection string
- i want to run an appliction when system is idle for more then 5 min
- How to save active page displayed through I.E.6 under text page.
- How can I connect to the internet with windows internet connections
- Program Execution Speed
Visual Basic
- Sub Main in Mainform.vb never getting called.
- RPC_E_CALL_REJECTED during Word automation from VB2005 when copying in Paint...
- How to use CAPICOM for digital signature using HEX encoding?
- Clearing a Array of Structures
- Check Whether The Barcode Reader Read A Barcode
- Application.DoEvents() resets my counters
- Supported Database
- get user's network name
- Allowing Only 1 Decimal "." in Textbox
- How can we lock Texbox,Combobox,Checkbox without disabling?
create sql table in vb.net code
Roberto Collina
yes.create a table in an application written in VB.NET but not in a database.
but store in sql server 2000 or 2005.
nhaas
a.s.viswa,
Please try the following code:
Private Sub BuildDataSet()
Dim objDS As New Data.DataSet("CustomerOrders")
Dim dtCustomers As Data.DataTable = objDS.Tables.Add("Customers")
Dim dtOrders As Data.DataTable = objDS.Tables.Add("Orders")
Dim objDR As Data.DataRow
With dtCustomers
.Columns.Add("CustomerID", Type.GetType("System.Int32"))
.Columns.Add("FirstName", Type.GetType("System.String"))
.Columns.Add("LastName", Type.GetType("System.String"))
.Columns.Add("Phone", Type.GetType("System.String"))
.Columns.Add("Email", Type.GetType("System.String"))
End With
With dtOrders
.Columns.Add("CustomerID", Type.GetType("System.Int32"))
.Columns.Add("OrderID", Type.GetType("System.Int32"))
.Columns.Add("OrderAmount", Type.GetType("System.Double"))
.Columns.Add("OrderDate", Type.GetType("System.DateTime"))
End With
objDS.Relations.Add("r_Customers_Orders", _
objDS.Tables("Customers").Columns("CustomerID"), _
objDS.Tables("Orders").Columns("CustomerID"))
objDR = dtCustomers.NewRow()
objDR("CustomerID") = 1
objDR("FirstName") = "Miriam"
objDR("LastName") = "McCarthy"
objDR("Phone") = "555-1212"
objDR("Email") = "tweety@hotmail.com"
dtCustomers.Rows.Add(objDR)
objDR = dtOrders.NewRow()
objDR("CustomerID") = 1
objDR("OrderID") = 22
objDR("OrderAmount") = 0
objDR("OrderDate") = #11/10/1997#
dtOrders.Rows.Add(objDR)
Console.WriteLine(objDS.GetXml())
End Sub
gafferuk
Hi
Sorry but I still do not understand what you are looking for.
Do you want to create a table in an application written in VB.NET but not in a database
Do you mean you want to create a temporary in-memory data table
Do you mean that you want to create a table in a database that is not SQL Server. If so, which database are you using
Richard
data_architect
I am using visual basic .net application,
that vb.net generate a code for create a sql table .
i am creating vb.net only not for sql server.
please help me.
leonreet
Hi
Do you want the TSQL ddl statement for creating a table (temp or perm) or are you looking for the code to create a connection and issue a command
Richard