protected void Page_Load(object sender, EventArgs e) { server = fetch.returnServer(); database = fetch.returnDB(); using (SqlConnection conn = new SqlConnection()) { conn.ConnectionString = "Server=" + server + ";Database=" + database + ";Trusted_Connection=true"; SqlCommand command = new SqlCommand(); SqlDataReader reader; try { conn.Open(); command = new SqlCommand("SELECT * FROM [" + database + "].[dbo].[ExperimentList] WHERE Id = '4';", conn); reader = command.ExecuteReader(); reader.Read(); titleText.Text = reader.GetString(1); objectivesText.Text = reader.GetString(2); procedureText.Text = reader.GetString(3); conn.Close(); } catch { titleText.Text = "Cannot connect to the database"; } } }
protected void Page_Load(object sender, EventArgs e) { server = fetch.returnServer(); database = fetch.returnDB(); using (SqlConnection conn = new SqlConnection()) { try { conn.ConnectionString = "Server=" + server + ";Database=" + database + ";Trusted_Connection=true"; conn.Open(); SqlCommand command = new SqlCommand("IF NOT EXISTS (SELECT * FROM SYSOBJECTS WHERE NAME='SensorData' AND XTYPE='U') CREATE TABLE [" + database + "].[dbo].[SensorData](Humidity nvarchar(MAX) NOT NULL DEFAULT '0',Temperature nvarchar(MAX) NOT NULL DEFAULT '0')", conn); command.ExecuteNonQuery(); conn.Close(); update(); } catch { } } }
protected void Page_Load(object sender, EventArgs e) { server = fetch.returnServer(); database = fetch.returnDB(); }