| | |
how to create database
Please support our VB.NET advertiser: Intel Parallel Studio Home
Thread Solved |
VB.NET Syntax (Toggle Plain Text)
[code = VB.NET] Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim con As SqlConnection Dim sql As String Dim cmd As SqlCommand con = New SqlConnection("Server=urserver;" & "DataBase=;" & "Integrated Security=ur security;") sql = "CREATE DATABASE ABC ON PRIMARY" + "(Name=abc_data, filename = 'C:\MSSQL7\data\abc.mdf', size=3," + "maxsize=5, filegrowth=10%)log on" + "(name=abc_log, filename='C:\MSSQL7\abc_log.ldf',size=3," + "maxsize=20,filegrowth=1)" con.Open() cmd = New SqlCommand(sql, con) Try cmd.ExecuteNonQuery() MsgBox("DATABASE Created") Catch ex As Exception MsgBox("Database Already Exists!") End Try End Sub
Regards,
Piya:)
Piya:)
![]() |
Similar Threads
- There is no menu choice to create a new database diagram (MS SQL)
- How do I create a database at run-time using VB6.0 (Visual Basic 4 / 5 / 6)
- How do i create a database in vb (Visual Basic 4 / 5 / 6)
- How to create a database during the runtime in VB6?! (Visual Basic 4 / 5 / 6)
- How to create a database, (Community Introductions)
- Need to know how to create a database that will generate a random number (Database Design)
Other Threads in the VB.NET Forum
- Previous Thread: DBdataset Dynamic file path
- Next Thread: Parse an xml stream
| Thread Tools | Search this Thread |
"crystal .net .net2005 30minutes 2008 access add advanced application array assignment basic binary box button buttons center click code combo connectionstring convert cpu data database databasesearch datagrid datagridview design designer dissertation dissertations dissertationthesis dosconsolevb.net editvb.net employees excel exists firewall folder forms image images isnumericfuntioncall listview login map math memory mobile module msaccess mssqlbackend mysql navigate net number opacity pan peertopeervideostreaming picturebox picturebox2 port print printpreview record regex reports" reuse right-to-left save savedialog search serial socket sqldatbase sqlserver storedprocedure string temp textbox timer txttoxmlconverter useraccounts usercontol usercontrol vb vb.net vb.netcode vb.nettoolboxvisualbasic2008sidebar vba vbnet vista visual visualbasic visualbasic.net visualstudio.net web wpf xml






