建dataset或datatable

[liyingzi]

我用asp:SqlDataSource连接asp:GridView显示，在aspx.vb 怎样用代码建dataset或datatable引用数据SqlDataSource

[nj_1st_excellence]

///<summary>

        ///创建一个DataSet对象

        ///</summary>

        /// <param name="str_sqlstr">SQL语句</param>

        /// <param name="str_table">表名</param>

        ///<returns>返回DataSet对象</returns>

        public DataSet getds(string str_sqlstr, string str_table)

        {

            SqlConnection sqlcon = this.getcon();

            SqlDataAdapter sqlda = new SqlDataAdapter(str_sqlstr, sqlcon);

            DataSet myds = new DataSet();

            sqlda.Fill(myds, str_table);

            return myds;

        }

這是C#的代碼， 自己看看，和VB大同小異

[liyingzi]

错误：不包含this.getcon();定义，要让它=asp:SqlDataSource连接asp:GridView

[wxg22526451]

用代码（网上很多）先创建dataset和datatable
然后 gridview的datasource=你建的DataTable，
再调用gridview的DataBind方法绑定数据就行了

[wsklt]

自己翻翻吧
[Quote=引用 2 楼 liyingzi 的回复:]
错误：不包含this.getcon();定义，要让它=asp:SqlDataSource连接asp:GridView
[/Quote]

[liyingzi]

请教，能让这段代码的查询结果显示在asp:GridView吗？
Function getdata() As System.Data.DataTable
Dim conn As New SqlConnection("data source=liming;initial catalog=zls;uid=sa;pwd=;")
Dim asapter As New SqlDataAdapter("select u.userid,u.username,u.address,u.typenumname,w.nmtabnum,w.amtabnum, w.typewatermeteprice,i.InTabManName from userinfo u left outer join usewaterinfo w on u.userid =w.userid INNER JOIN InTabManMS AS i ON u.InTabManID = i.InTabManID where u.userid="+textbox1.text+"w.payyesno= 0 order by w.id", conn)
Dim mydataset As New DataSet()
Dim ex As Exception
Try
asapter.Fill(mydataset, "customer")
Catch ex
Response.Write(ex.ToString())
End Try
Return (mydataset.Tables(0))
End Function
End Class