public bool Crear() { OdbcConnection oConnection = this.OpenConnection(); OdbcDataAdapter myConsulta; DataTable dt = new DataTable(); myConsulta = new OdbcDataAdapter("SELECT Nombre, Apellido FROM Personas WHERE dni = " + int.Parse(strDocumento), oConnection); myConsulta.Fill(dt); if (dt.Rows.Count > 0) { return(false); } String strSQL = "Insert into Personas (Nombre, Apellido, "; strSQL = strSQL + "EstadoCivil, Tipodni, DNI, Calle, Nro, Dpto, Piso, Barrio, CP, idLocalidad, idProvincia) "; strSQL = strSQL + " values ('" + Nombre + "','" + Apellido.Replace("'", "''") + "',"; strSQL = strSQL + intEstadoCivil + "," + intTipoDocumento + ",'" + strDocumento; strSQL = strSQL + "','" + strCalle + "','" + strNro + "','" + strDpto + "','" + strPiso + "','" + strBarrio + "','" + strCP + "'," + intLocalidad.ToString() + "," + intProvincia.ToString() + ")"; try { OdbcCommand myCommand = new OdbcCommand(strSQL, oConnection); myCommand.ExecuteNonQuery(); oConnection.Close(); } catch (Exception e) { string p = e.Message; return(false); } return(true); }