public static void UpdateDatabase2FromJS()
{
Random random = new Random();
SQL_vb_connector vb_con = new SQL_vb_connector(SqlConProp.domain, SqlConProp.database2, SqlConProp.login, SqlConProp.pass);
vb_con.UpdateTable("Table1", "name", random.Next(100));
vb_con.Disconnect();
}
private void button6_Click(object sender, EventArgs e)
{
if (vb_con != null)
{
vb_con.Disconnect();
this.dataGridView1.DataSource = null;
vb_con = null;
}
}
protected void Button7_Click(object sender, EventArgs e)
{
SQL_vb_connector vb_con = new SQL_vb_connector(SqlConProp.domain, SqlConProp.database2, SqlConProp.login, SqlConProp.pass);
this.GridView1.DataSource = vb_con.SelectTable("Table1");
this.GridView1.DataBind();
this.GridView1.Visible = true;
vb_con.Disconnect();
}
protected void Button8_Click(object sender, EventArgs e)
{
Random random = new Random();
SQL_vb_connector vb_con = new SQL_vb_connector(SqlConProp.domain, SqlConProp.database2, SqlConProp.login, SqlConProp.pass);
vb_con.UpdateTable("Table1", "name", random.Next(100));
this.GridView1.DataSource = vb_con.SelectTable("Table1");
this.GridView1.DataBind();
this.GridView1.Visible = true;
vb_con.Disconnect();
}
private void button5_Click(object sender, EventArgs e)
{
vb_con = new SQL_vb_connector("192.168.8.99", "TestDatabase2", "Administrator", "Pa$$word");
this.dataGridView1.DataSource = vb_con.SelectTable("Table1");
}
