mysql dataadapter.fill_为什么dataadapter.fill没有把数据填充进去

protectedvoidPage_Load(objectsender,EventArgse){conn=newSqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);co...

protected void Page_Load(object sender, EventArgs e)

{

conn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);

conn.Open();

if (!IsPostBack)

{

string instruction = "select pid,title,uname,contents ,postTime from Posts where isOver=0 order by postTime desc";

Bind(instruction);

}

}

protected void Bind( string s)

{

string instruction = s;

try

{

SqlDataAdapter DA = new SqlDataAdapter(instruction, conn);

DataSet ds = new DataSet();

DA.Fill(ds);

GridView1.Columns.Clear();

GridView1.DataSource = ds;

GridView1.DataBind();

conn.Close();

}

catch (Exception ee)

{

MessageBox.Show(ee.ToString());

}

}

调试的时候发现ds这个dataset在DA.Fill(ds);之后还是空的，但是我直接在数据库里查询是能查出数据的，请问为什么会这样啊，急急急

展开