代码:不知道错在那儿

Question

private void button3_Click(object sender, EventArgs e)
        {
            SqlConnection Sqlcon = new SqlConnection(connection);            SqlDataAdapter Sda = new SqlDataAdapter("select * from ts",Sqlcon);            DataSet Ds= new DataSet();                        //这一行通不过
            //提示错误为:未将对象引用设置到对象的实例。
            Ds.Tables["ts"].Rows[0].Delete();            Sda.Update(Ds);                    }

Answer 1

if(Ds.Table["ts"].Row.count>0)
{
            //这一行通不过
            //提示错误为:未将对象引用设置到对象的实例。
            Ds.Tables["ts"].Rows[0].Delete();            Sda.Update(Ds);
}

Answer 2

你没有Fill呀
Sda.fill(ds)
好像是这样的，具体的我也忘记了，看一下MSDN吧

Answer 3

private void button3_Click(object sender, EventArgs e)
        {
            SqlConnection Sqlcon = new SqlConnection(connection);            SqlDataAdapter Sda = new SqlDataAdapter("select * from ts",Sqlcon);            DataSet Ds= new DataSet();            Sda.Fill(Ds,"ts");            
            Ds.Tables[0].Rows[0].Delete();         错误: //当传递具有已删除行的 DataRow 集合时，更新要求有效的 DeleteCommand。
            Sda.Update(Ds,"ts");                    }

Answer 4

private void button3_Click(object sender, EventArgs e)
        {
            SqlConnection Sqlcon = new SqlConnection(connection);            SqlDataAdapter Sda = new SqlDataAdapter("select * from ts",Sqlcon);            SqlCommandBuilder cmb = new SqlCommandBuilder(Sda);//加这句            Sda.DeleteCommand = cmb.GetDeleteCommand();//加这句            DataSet Ds= new DataSet();            Sda.Fill(Ds,"ts");            
            Ds.Tables[0].Rows[0].Delete();         错误: //当传递具有已删除行的 DataRow 集合时，更新要求有效的 DeleteCommand。
            Sda.Update(Ds,"ts");                    }

Answer 5

private   void   button3_Click(object   sender,   EventArgs   e) 
                { 
                        SqlConnection   Sqlcon   =   new   SqlConnection(connection);                         SqlDataAdapter   Sda   =   new   SqlDataAdapter( "select   *   from   ts ",Sqlcon);                         DataSet   Ds=   new   DataSet();                         sda.fill(ds,"ts")if (ds.tables("ts").rows.count>0)
{
                        Ds.Tables[ "ts "].Rows[0].Delete(); 
}
                        Sda.Update(Ds);                                         }

Answer 6

cao ni ma
人家up也得分