ADO.NET 相关笔记（2008-5-25）

连接数据库代码： //设置连接字符串            string conn = "Data Source = TRAUM//sqlexpress;Database = master;User ID = sa ;Password = 123456 ";            SqlConnection sqlcon = new SqlConnection(conn);                       sqlcon.Open();  //don't forget to sqlcon.close() //SqlCommand-insert,query,modify,delete and so on....          //query website/hello/ado1.aspx.cs SqlCommand sqlcmd = sqlcon.CreateCommand();            sqlcmd.CommandText = "SELECT optname,value,major_version from MSreplication_options";             SqlDataReader thisReader = sqlcmd.ExecuteReader();       //don't forget to close       .........    //insert  见website/hello/ado1.aspx.cs string strInsert =string.Format( "insert into article(title,writer,content) values ('{0}','{1}','{2}')",strTitle,strWriter,strContent); sqlcmd = new SqlCommand(strInsert,sqlcon); sqlcmd.ExecuteNonQuery();