<%@ Page Language="vb" Debug="true" %> <% @Import NameSpace="System.Data" %> <% @Import NameSpace="System.Data.SQLClient" %> <% @Import NameSpace="System.Diagnostics.Debug" %> <% @Import Namespace="System.Web.Mail" %> <% @Import Namespace="System.Text.RegularExpressions" %> <% @Import NameSpace="System.Data.OleDb" %> <%@ Import namespace="System.IO" %> <%@ Import namespace="System.Net" %> <% 'Dim strConn = ("server=PICCOLO8-4FC49E;uid=sa;pwd=sa;database=low") Dim strConn = ("server=62.149.153.14; initial catalog=MSSql14112;uid=MSSql14112;pwd=3d2c957f") Dim sqlConn As New SqlConnection(strConn) Dim SqlComm as New SqlCommand Dim r as SqlDatareader Dim result As Integer sqlConn.Open() sqlComm = New SqlCommand("DROP TABLE Quest " ,sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("DROP TABLE Item_Quest " ,sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("DROP TABLE Artefact " ,sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("Create Table Quest ( " & _ "[Id_Quest] [int] IDENTITY (1, 1) NOT NULL , " & _ "[Number_Items] [int] NULL , " & _ "[Item_Name] [varchar] (50) COLLATE Latin1_General_CI_AS NULL , " & _ "[Total_Item] [varchar] (50) COLLATE Latin1_General_CI_AS NULL , " & _ "[Title_Quest] [varchar] (100) COLLATE Latin1_General_CI_AS NULL , " & _ "[Description] [varchar] (3000) COLLATE Latin1_General_CI_AS NULL , " & _ "[Quest_Status] [varchar] (50) COLLATE Latin1_General_CI_AS NULL , " & _ "[Date_Start] [datetime] NULL , " & _ "[Date_End] [datetime] NULL , " & _ "[Winner] [varchar] (50) COLLATE Latin1_General_CI_AS NULL , " & _ "[Prize_Quantity] [int] NULL , " & _ "[Prize_Resource] [varchar] (50) COLLATE Latin1_General_CI_AS NULL , " & _ "[Prize_Artefact] [int] NULL , " & _ ")",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("Create Table Item_Quest ( " & _ "[Id_Utente] [int] NULL , " & _ "[Id_Quest] [int] NULL , " & _ "[Item_Name] [varchar] (50) COLLATE Latin1_General_CI_AS NULL , " & _ ")",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("Create Table Artefact ( " & _ "[Id] [int] IDENTITY (1, 1) NOT NULL , " & _ "[Id_Utente] [int] NULL , " & _ "[Artefact_Name] [varchar] (100) COLLATE Latin1_General_CI_AS NULL , " & _ "[Artefact_Desc] [varchar] (1000) COLLATE Latin1_General_CI_AS NULL , " & _ "[Artefact_Bonus_How] [int] NULL , " & _ "[Artefact_Bonus_Type] [varchar] (10) COLLATE Latin1_General_CI_AS NULL , " & _ "[Artefact_Bonus_Who] [int] NULL , " & _ ")",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() %>