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(); }
private void button1_Click(object sender, EventArgs e) { if (cs_con == null) { log.Info("Connecting to DB"); //cs_con = new SQL_cs_connector("192.168.8.99", "TestDatabase1", "Administrator", "Pa$$word"); cs_con = new SQL_cs_connector(); cs_con.SetLogger(log); cs_con.Connect(ConfigurationManager.AppSettings["DBconnStr"]); this.dataGridView1.DataSource = cs_con.SelectTable("Table1"); } }