public static void UpdateDatabase1FromJS() { Random random = new Random(); SQL_cs_connector cs_con = new SQL_cs_connector(SqlConProp.domain, SqlConProp.database1, SqlConProp.login, SqlConProp.pass); cs_con.UpdateTable("Table1", "name", random.Next(100)); cs_con.Disconnect(); }
private void button4_Click(object sender, EventArgs e) { if (cs_con != null) { cs_con.Disconnect(); this.dataGridView1.DataSource = null; cs_con = null; } }
protected void Button1_Click(object sender, EventArgs e) { SQL_cs_connector cs_con = new SQL_cs_connector(SqlConProp.domain, SqlConProp.database1, SqlConProp.login, SqlConProp.pass); this.GridView1.DataSource = cs_con.SelectTable("Table1"); this.GridView1.DataBind(); this.GridView1.Visible = true; cs_con.Disconnect(); }
protected void Button12_Click(object sender, EventArgs e) { SQL_cs_connector cs_con = new SQL_cs_connector(SqlConProp.domain, SqlConProp.database1, SqlConProp.login, SqlConProp.pass); int nId = Int32.Parse(this.TextBox1.Text); this.GridView1.DataSource = cs_con.CallStoreProc("GetTableFromId", nId); this.GridView1.DataBind(); this.GridView1.Visible = true; cs_con.Disconnect(); }
protected void Button2_Click(object sender, EventArgs e) { Random random = new Random(); SQL_cs_connector cs_con = new SQL_cs_connector(SqlConProp.domain, SqlConProp.database1, SqlConProp.login, SqlConProp.pass); cs_con.UpdateTable("Table1", "name", random.Next(100)); this.GridView1.DataSource = cs_con.SelectTable("Table1"); this.GridView1.DataBind(); this.GridView1.Visible = true; cs_con.Disconnect(); }