vs2008配置数据源问题，急！

Question

本帖最后由 zhouhappy 于 2011-04-19 11:52:43 编辑

Answer 1

string sql = "select * from ....";
            this.GridView1.DataSource = GetDate(sql);
            this.GridView1.DataBind(); public DataTable GetDate(string sql)
        {
            SqlConnection cn = new SqlConnection();
            cn.ConnectionString = "连接字符串";
            SqlCommand cmd = new SqlCommand();
            DataTable dt = new DataTable();
            SqlDataReader dr = null;
            cmd.CommandText = sql;
            cmd.Connection = cn;
            using (dr = cmd.ExecuteReader(CommandBehavior.CloseConnection))
            {
                dt.Load(dr);
            }
            if (dt.Rows.Count != 0)
            {
                return dt;
            }
            else
            {
                return null;
            }
        }