asp.net-“string”不包含“Fill”的定義

“string”不包含“Fill”的定義

我嘗試在gridview控件顯示該用戶發表過的語句；然而他顯示：錯誤 1 “string”不包含“Fill”的定義，並且找不到可接受類型為“string”的第一個參數的擴展方法“Fill”(是否缺少 using 指令或程序集引用?) C:\Users\Administrator\Desktop\練習\聊天室\gllyb.aspx.cs 49 17 聊天室
該怎麼解決；向各位大神求教。
代碼如下
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Configuration;
using System.Data.SqlClient;
using System.Collections;

public partial class liuyanban : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
Label2.Text = "當前在線人數為" + Application["count"].ToString() + "人";
Label2.Text = Session["UserID"].ToString();

}

protected void Button_send_Click(object sender, EventArgs e)
{

    string took = TextBox1.Text;
    string connString = System.Configuration.ConfigurationManager.ConnectionStrings["talkroomConnectionString"].ConnectionString;
    SqlConnection myConn = new SqlConnection(connString);
    string sqlStr = " insert into liaotian(用戶名,時間,內容) values('" + Session["UserID"].ToString() + "','" + System.DateTime.Now.ToString() + "','" + TextBox1.Text .ToString() + "') ";
    SqlCommand myCmd = new SqlCommand(sqlStr, myConn);
    myConn.Open();
    myCmd.ExecuteNonQuery();
    myConn.Close();
    TextBox1.Text = " ";
    GridView1.DataBind ();
}

protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{

}
protected void Button1_Click(object sender, EventArgs e)
{
    SqlConnection sqlCon = new SqlConnection();
    sqlCon.ConnectionString = "server=PC201503061527;uid=sa;pwd=sa;database=talkroom";
    sqlCon.Open();
    string sql = string.Format("select * from liaotian where 用戶名='{0}' ", Session["UserID"].ToString());
    try
    {
        SqlCommand cmd = new SqlCommand(sql, sqlCon);
        DataSet dadaset = new DataSet("liaotian");
        sql.Fill(dadaset);
        this.GridView1.DataSourceID = null;
        GridView1.DataSource = dadaset.Tables[0];
        GridView1.DataBind();

    }
    catch
    { 

    }
}

}

最佳回答：

你的sql是字符串變量，字符串變量就沒有Fill的方法。。要用SqlDataAdapter對象填充DataSet

       try
        {
            //SqlCommand cmd = new SqlCommand(sql, sqlCon);
            SqlDataAdapter da = new SqlDataAdapter(sql, sqlCon);
            DataSet dadaset = new DataSet("liaotian");
            da.Fill(dadaset);
            this.GridView1.DataSourceID = null;
            GridView1.DataSource = dadaset.Tables[0];
            GridView1.DataBind();

        }
        catch
        {

        }