protected void Page_Load(object sender, EventArgs e) { string conn = "server=192.168.104.117;uid=wftsa;password=jd7nTF#wM;database=k2Sln"; //object dt = db.ExecScalarInt(" select top 22 * from k2sln.dbo.TB_SNDA_Common_VirtualRole "); //Response.Write(dt); DbMap map = new DbMapSqlServer(conn); // string sql = "select top 1 * from k2sln.dbo.TB_SNDA_Common_VirtualRole where idx=27617"; // IDataReader dr = map.db.GetReader(sql); // VirtualRole1 role = map.Get<VirtualRole1>(sql); // Response.Write(role.Proccode); //insert : //VirtualRole1 vr = new VirtualRole1() //{ // Proccode = "njhtext", // RoleGroupCode = "njhtest", // RoleGroupName = "njhtest", // SpecialPersonid = "snda\\niejunhua", //}; ////int rs = map.Insert<VirtualRole1>(vr); //// Response.Write(rs); //vr = new VirtualRole1(); //vr = map.Get<VirtualRole1>(sql); //vr.Proccode = "njhprocvcode"; //int idd = map.Update<VirtualRole1>(vr); //Response.Write(idd); SqlServerModeCreate core = new SqlServerModeCreate(conn); core.CreateAll("", "K2SLN"); }