楼主，自己百度一下，代码就有了。几乎所有讲asp.net基础知识的书里，都会有例子的。 这是根据我的三成改的！！你只用一成的话！就没必要创建user对象了！！直接给sql语句赋值句好了！！ C# code: User user = new User(); user.LoginId = this.txtname.Text; user.LoginPwd = this.txtRespPwd.Text; user.Name = this.txtTrueName.Text; user.Phone = this.txtPhone.Text; user.Mail = this.txtEmail.Text; user.Address = this.txtAddrse.Text; user.UserRole = new UserRole(1);
string str = ConfigurationManager.ConnectionStrings["connstr"].ToString(); SqlConnection conn = new SqlConnection(str); string sql = "insert into users values(@LoginId,@LoginPwd,@Name,@Address,@Phone,@Mail,@UserRoleId,@UserStateId)" SqlParameter[] para = new SqlParameter[] { new SqlParameter ("@LoginId",user.LoginId), new SqlParameter("@LoginPwd",user.LoginPwd), new SqlParameter("@Name",use
select top 12 * from Product where [id] not in (select top 12 [id] from Product) 这样可以分页，但是我在后面想加个条件 select top 12 * from Product where [id] not in (select top 12 [id] from Prod ......
