17-12-22, 11:50 AM
من خلال الكود
تم انشاء القاعدة باستخدام الامر
con = New SqlConnection("Data source=DESKTOP-49TQGM0;Initial Catalog=master;Integrated Security=True;MultipleActiveResultSets=True")
con.Open()
Dim cb3 As String = "Create Database My_DB"
cmd = New SqlCommand(cb3)
cmd.Connection = con
cmd.ExecuteNonQuery()
con.Close()
con = New SqlConnection("Data Source=DESKTOP-49TQGM0;Initial Catalog=My_DB;Integrated Security=True")
Using sr As StreamReader = New StreamReader(Application.StartupPath & "\script.sql")
st = sr.ReadToEnd()
Dim server As New Server(New ServerConnection(con))
server.ConnectionContext.ExecuteNonQuery(st)
End Using
وهناك ملف اسكربت لانشاء الجداول
يظهر خطا
علما بانه يتم الانشاء عند تنفيذ الامر من داخل السكول ويتم الانشاء
يظهر خطا
An unhandled exception of type 'System.IO.FileNotFoundException' occurred in mscorlib.dll
Additional information: Could not load file or assembly 'Microsoft.SqlServer.BatchParser, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
تم انشاء القاعدة باستخدام الامر
con = New SqlConnection("Data source=DESKTOP-49TQGM0;Initial Catalog=master;Integrated Security=True;MultipleActiveResultSets=True")
con.Open()
Dim cb3 As String = "Create Database My_DB"
cmd = New SqlCommand(cb3)
cmd.Connection = con
cmd.ExecuteNonQuery()
con.Close()
con = New SqlConnection("Data Source=DESKTOP-49TQGM0;Initial Catalog=My_DB;Integrated Security=True")
Using sr As StreamReader = New StreamReader(Application.StartupPath & "\script.sql")
st = sr.ReadToEnd()
Dim server As New Server(New ServerConnection(con))
server.ConnectionContext.ExecuteNonQuery(st)
End Using
وهناك ملف اسكربت لانشاء الجداول
يظهر خطا
علما بانه يتم الانشاء عند تنفيذ الامر من داخل السكول ويتم الانشاء
يظهر خطا
An unhandled exception of type 'System.IO.FileNotFoundException' occurred in mscorlib.dll
Additional information: Could not load file or assembly 'Microsoft.SqlServer.BatchParser, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
