the last record cannot be deleted

[ahmedlasheen]

hello every body
when iam trying to delete the last record in DGV this erro appears
"Input string was not in a correct format."
this error appears only when i am trying to delete the last record.
.
the code i using is the following

public void Delete(int id)
        {
            ////////////Delete the record from the dataset.///////////
            DataRow[] DR = dttel.Select("id=" + id + "");
            DR[0].Delete();
        }
 
 
 
 
        public void UpdateTelephone(
            int id,
         string name,
         string title,
         string home_phone,
         string mobile_phone,
         string address,
         string notes)
 
        {
            //Insert a new record in the Databse.
            string Insert_Str = "insert into tel( " +
            "name," +
            "title," +
            "home_phone," +
            "mobile_phone," +
            "address,notes)" +
            " values ("+
            " '"+name+"'         ,"+
            " '"+title+"'        ,"+
            " '"+home_phone+"'   ,"+
            " '"+mobile_phone+"' ,"+
            " '"+address+"'      ,"+
            " '"+notes+"'        )";
            //////////////Update a new record in the Database.
            string Update_str = "update  tel set " +
                        "name='"+name+"'," +
                        "title='"+title+"'," +
                        "home_phone='"+home_phone+"',"+
                        "mobile_phone='"+mobile_phone+"'," +
                        "address='"+address+"'," +
                        "notes='"+notes+"'"+
                        "where id="+id+" ";
            ////////////Delete the record from the Database.
            string Delete_str = "delete from tel where id= " + id + " ";
            ////////////////defining sqlcommands////////////////////
            OleDbCommand Insert_Cmd = new OleDbCommand(Insert_Str, MyConnection.connect());
            OleDbCommand Update_cmd = new OleDbCommand(Update_str, MyConnection.connect());
            OleDbCommand Delete_cmd = new OleDbCommand(Delete_str, MyConnection.connect());
            ////////////////Defining the adapter command////////////
            DA.InsertCommand = Insert_Cmd;
            DA.UpdateCommand = Update_cmd;
            DA.DeleteCommand = Delete_cmd;
            ////////////////update the datasource.///////////////////////
            try
             {
               DA.Update(dttel);
             }
             catch (OleDbException ex)
            {
                MessageBox.Show("Warning" + ex.Message,
                "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
            }
        }

can any body help me.

[leoiser]

it seems something wrong with your query.Make sure your query is running fine...may be single quotes in one of the values may cause the problem

for example if you put address as leoiser's home in that single quotes will break the query,so replace everything with replace single quotes to two single quotes..

address.Replace("'","''");

Thanks

[Shashi Sadasivan]

Could you please tell which line is causing that exception!

Along with the string that was generated (can be picjked up from debug mode)