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();
}
