搞IT的蟋蟀

摘要： 1 private void button1_Click(object sender, EventArgs e) 2 { 3 StringBuilder sql =new StringBuilder("select * from tblBook"); 4 List list=new List(); 5 List listspt = new List(); 6 if(textBox1.Text.Trim().Length>0) 7 { 8 ... 阅读全文

摘要： 1 public static class SqlHelper 2 { 3 //通过配置文件获取连接字符创 4 private static readonly string constr = ConfigurationManager.ConnectionStrings["str"].ConnectionString; 5 /// 6 /// 执行增,删,改的方法 7 /// 8 /// 要执行的sql语句 9 /// 参数化查询的参数10 /// 影响... 阅读全文

摘要： insert into [table] output inserted.columnName values(); 阅读全文

摘要： 1 { 90 #endregion 91 #region 数据导入 92 string constr = "data source=.;initial catalog=itcast2013;integrated security=true"; 93 using (StreamReader sr = new StreamReader(@"f:\person.txt")) 94 { 95 using (SqlConnection con = n... 阅读全文