GridView绑定数据

[a6389639]

我想把查询出来的数据绑定到GridView里 在这里怎么写啊

 protected void btnUSearch_Click(object sender, EventArgs e)
    {
        string loginId = this.txtUSearch.Text.Trim();
        string u=UserManager.GetUserByLoginId(loginId);
        return;
    }

[a6389639]

我试了，调试的后显示 数据源类型无效。它必须是 IListSource、IEnumerable 或 IDataSource。

[yfxucn]

还羡慕可以使用GridView 哎.......

[naonaoye]

UserManager.GetUserByLoginId(loginId);的返回值是什么？

DataSet和DataTable都可以啊

[ronadozj]

sqlcommond cmd = new sqlcommond("select "+u,connection);
sqldataadapter da = new sqldataadapter(cmd);
dataset ds = new dataset();
da.fill(ds);
GridView1.DataSource=ds.table[0].defaultview;
GridView1.DataBind();

[ronadozj]

前面string等于的肯定是string了
[Quote=引用 12 楼 naonaoye 的回复:]
UserManager.GetUserByLoginId(loginId);的返回值是什么？

DataSet和DataTable都可以啊
[/Quote]

[a6389639]

不行啊 总是提示 数据类型无效 。 我这个方法是为了把查询以后的数据放到GridView上

[a6389639]

哪个方法调用的这个方法

 public static User GetUserByLoginId(string loginId)
        {
            string sql = "SELECT * FROM Users WHERE LoginId = @LoginId";
            int userStateId;
            int userRoleId;
            using (SqlDataReader reader = DBHelper.GetReader(sql, new SqlParameter("@LoginId", loginId)))
            {
                if (reader.Read())
                {
                    User user = new User();

                    user.Id = (int)reader["Id"];
                    user.LoginId = (string)reader["LoginId"];
                    user.LoginPwd = (string)reader["LoginPwd"];
                    user.Name = (string)reader["Name"];
                    user.Address = (string)reader["Address"];
                    user.Phone = (string)reader["Phone"];
                    user.Mail = (string)reader["Mail"];
                    userStateId = (int)reader["UserStateId"]; //FK
                    userRoleId = (int)reader["UserRoleId"]; //FK
                    reader.Close();
                    user.UserState = UserStateService.GetUserStateById(userStateId);
                    user.UserRole = UserRoleService.GetUserRoleById(userRoleId);

                    return user;
                }
                else
                {
                    reader.Close();
                    return null;
                }
            }
        }

[fd1985318]

GetUserByLoginId(loginId)返回的是字符串？绑定gridview需要dataset或者datatable

[手可摘星辰]

你写那什么玩意啊，都看不懂。给个数据源就行了啊，数组，datatable,集合什么的都行啊

[se7en]

gridview.bind bind方法就是帮顶

[a6389639]

 string loginId = this.txtUSearch.Text.Trim();
        DataTable da = new DataTable();
        da=UserManager.GetUserByLoginId(loginId);
        gvMain.DataBind();

错误 1 无法将类型“MyBookShop.Models.User”隐式转换为“System.Data.DataTable”

[新时代新目标新征程]

 protected void btnUSearch_Click(object sender, EventArgs e)
        {
            string loginId = this.txtUSearch.Text.Trim();
            string u = UserManager.GetUserByLoginId(loginId);
            DataSet ds = new DataSet();
            ds = //你写sql语句形成数据源
            gridview//绑定应该会吧
           
        }

大哥你去看下书好吗？这个很简单的。你的gridvie要绑定数据源为dataset，那你把你的查询条件加到你的sql语句上重新执行下。形成个dataset，再绑定不就可以了吗。

[ZhuZhuYuXiang]

json序列化

[a6389639]

[Quote=引用 21 楼 chuntian1983 的回复:]
C# code
protected void btnUSearch_Click(object sender, EventArgs e)
{
string loginId = this.txtUSearch.Text.Trim();
string u = UserManager.GetUserByLoginId(loginId……
[/Quote]
我用你的方法 总数提示数据源类型无效

[laolaolai]

你的问题根本原因是：
GetUserByLoginId方法返回的是一个用户对象User
而绑定GridView需要提供的数据源应该是实现了IListSource、IEnumerable 或 IDataSource的对象
比如DataSet DataTable DataTable.DefaultView List

所以你应该这样：
你可以把User对象放到List<User>中，也可以将其放到DataTable中，都可以啊。
而不能直接将User实例直接赋给GridView.DataSource，这样说楼主明白了吗？

[满庭花醉三千客]

  protected void btnUSearch_Click(object sender, EventArgs e)
    {
        string loginId = this.txtUSearch.Text.Trim();        
        List<User> list = new List<User>();
        list.Add(UserManager.GetUserByLoginId(loginId));
        GridView1.DataSource=list;
        GridView1.DataBind();
    }

试试看

[手可摘星辰]

[Quote=引用 20 楼 a6389639 的回复:]
C# code
string loginId = this.txtUSearch.Text.Trim();
DataTable da = new DataTable();
da=UserManager.GetUserByLoginId(loginId);
gvMain.DataBind();



错误 1 无法将类型“MyBook……
[/Quote]
因为你那边查询的方法返回的是实体类型的，你要返回datatable或集合啊

[arjen2010]

UserManager.GetUserByLoginId(loginId);这个方法要返回一个DATATABLE

[手可摘星辰]

public static DataTable GetUserByLoginId(string loginId)
        {
            datatable dt = new datatable();
            string sql = "SELECT * FROM Users WHERE LoginId = @LoginId";
            int userStateId;
            int userRoleId;
            using (SqlDataReader reader = DBHelper.GetReader(sql, new SqlParameter("@LoginId", loginId)))
            {
                if (reader.Read())
                {
                    User user = new User();

                    user.Id = (int)reader["Id"];
                    user.LoginId = (string)reader["LoginId"];
                    user.LoginPwd = (string)reader["LoginPwd"];
                    user.Name = (string)reader["Name"];
                    user.Address = (string)reader["Address"];
                    user.Phone = (string)reader["Phone"];
                    user.Mail = (string)reader["Mail"];
                    userStateId = (int)reader["UserStateId"]; //FK
                    userRoleId = (int)reader["UserRoleId"]; //FK
                    reader.Close();
                    user.UserState = UserStateService.GetUserStateById(userStateId);
                    user.UserRole = UserRoleService.GetUserRoleById(userRoleId);
                    
                    return dt;
                }
                else
                {
                    reader.Close();
                    return null;
                }
            }
        }

你把这个再改改吧，就是返回类型不对，用datatable了就没必要写的这么麻烦

[满庭花醉三千客]

public static List<User> GetUserByLoginId(string loginId)
        {
             List<User> list = new List<User>();
            string sql = "SELECT * FROM Users WHERE LoginId = @LoginId";
            int userStateId;
            int userRoleId;
            using (SqlDataReader reader = DBHelper.GetReader(sql, new SqlParameter("@LoginId", loginId)))
            {
                if (reader.Read())
                {
                    User user = new User();

                    user.Id = (int)reader["Id"];
                    user.LoginId = (string)reader["LoginId"];
                    user.LoginPwd = (string)reader["LoginPwd"];
                    user.Name = (string)reader["Name"];
                    user.Address = (string)reader["Address"];
                    user.Phone = (string)reader["Phone"];
                    user.Mail = (string)reader["Mail"];
                    userStateId = (int)reader["UserStateId"]; //FK
                    userRoleId = (int)reader["UserRoleId"]; //FK
                    reader.Close();
                    user.UserState = UserStateService.GetUserStateById(userStateId);
                    user.UserRole = UserRoleService.GetUserRoleById(userRoleId);
                    list.Add(user);
                }
                else
                {
                    reader.Close();
                }
            }
           return list;
        }

  protected void btnUSearch_Click(object sender, EventArgs e)
    {
        string loginId = this.txtUSearch.Text.Trim();
        GridView1.DataSource=UserManager.GetUserByLoginId(loginId);
        GridView1.DataBind();
    }