private void button9_Click(object sender, EventArgs e) { foreach (string s in MsSql.getColumnsName("t_user")) { MessageBox.Show(s); } }
private void button7_Click(object sender, EventArgs e) { DataTable dt = new DataTable(); dt = MsSql.Table("SELECT u.cn, u.Name, u.Lastname FROM dbo.t_user AS u WHERE cn = @cn", new string[] { "1" }); foreach (DataRow dr in dt.Rows) { MessageBox.Show(dr["Name"].ToString()); } }
private void button5_Click(object sender, EventArgs e) { MsSql.ExecuteQuery("INSERT INTO t_user (Name, Lastname) VALUES (@name, @Lastname)", new string[] { "name1", "lastname1" }); }