protected void Button1_Click(object sender, EventArgs e)
{
string SQL = "insert into tbluserlogin ( username, userpassword, securitylevel) values ('" + TextBox1.Text + "','anything','A');";
DataAccess.db myDA = new DataAccess.db();
myDA.connectionstring = "Data Source=devrystudentsp10.db.6077598.hostedresource.com;Initial Catalog=DeVryStudentSP10;User Id=DeVryStudentSP10;Password=OidLZqBv4;";
myDA.Execute(SQL);
LoadData();
}
private void LoadData()
{
DataAccess.db myDA = new DataAccess.db();
System.Data.SqlClient.SqlDataReader dr;
myDA.connectionstring = "Data Source=devrystudentsp10.db.6077598.hostedresource.com;Initial Catalog=DeVryStudentSP10;User Id=DeVryStudentSP10;Password=OidLZqBv4;";
dr = myDA.GetData("select * from tbluserlogin");
while (dr.Read())
{
Response.Write(dr.GetValue(1).ToString() + "<br />");
}
}