在调用“Fill”前，SelectCommand 属性尚未初始化。

[canylove]

Sda.DeleteCommand = new SqlCommand();
Sda.DeleteCommand.Connection = conn;
Sda.DeleteCommand.CommandType = CommandType.Text;
Sda.DeleteCommand.CommandText = "delete from phone where id='" + TextBox3.Text + "'";
conn.Open();
Sda.Fill(Ds, "LocalView");
GridView1.DataSource = Ds.Tables["LocalView"].DefaultView;
GridView1.DataBind();
conn.Close();
红字部分：在调用“Fill”前，SelectCommand 属性尚未初始化
请问什么原因

[shuishixu]

Sda.DeleteCommand.ExecuteNonQuery()先

[fuzijing]

SelectCommand 属性尚未初始化 ???

fill不能执行删除？

mark一下，看看！

[jiang_jiajia10]

改一下你的代码

      string sql = "delete from phone where id='" + TextBox3.Text + "'"; 
       conn.Open();
        SqlCommand cmd = new SqlCommand(sql , conn);
        try
        {

            cmd.ExecuteNonQuery();
            conn.Close();
        }
        catch (System.Exception e) {

            conn.Close();
        }        
        SqlDataAdapter dbAdapter = new SqlDataAdapter(你要帮顶的语句？, conn);
        DataSet ds = new DataSet();
        Sda.Fill(ds, "LocalView"); 
        GridView1.DataSource = Ds.Tables["LocalView"].DefaultView; 
        GridView1.DataBind(); 
        conn.Close(); 

[bydxyj]

conn.Open();
SqlCommand cmd = new SqlCommand();
SqlDataAdapter Sda = new SqlDataAdapter();
Sda.SelectCommand = new SqlCommand("select * from stu_score2", conn);//初始化SelectCommand

cmd.Connection = conn;
cmd.CommandText = "delete from phone where id='" + TextBox3.Text + "'";
cmd.CommandType = CommandType.Text;
Sda.DeleteCommand = cmd;
Sda.DeleteCommand.ExecuteNonQuery();//执行delete

DataSet Ds = new DataSet();

Sda.Fill(Ds, "LocalView");//使用Fill方法需要指定Select语句
GridView1.DataSource = Ds.Tables["LocalView"].DefaultView;
GridView1.DataBind();
conn.Close();

修改了下，希望有帮助

[bydxyj]

如果只是要执行删除操作，按照3楼的就可以了！